On Wed, Nov 28, 2007 at 05:06:45PM +0100, Matt Doughty wrote: > Hi, > > Is there a way of selecting all fields except for one in particular? > I'd like to create a query that says something like: > > select * except fieldx > > What I'm hoping to achieve is a query that can be valid for a number > of different tables, although the field I don't want to select is > always called the same (field_not_wanted, for example). This sounds like self-modifying code. I'd submit that you're trying to do the wrong thing in the first place, and that you should look over your design for flaws like this and re-do that design. Cheers, David. -- David Fetter <david@xxxxxxxxxx> http://fetter.org/ Phone: +1 415 235 3778 AIM: dfetter666 Yahoo!: dfetter Skype: davidfetter XMPP: david.fetter@xxxxxxxxx Remember to vote! Consider donating to Postgres: http://www.postgresql.org/about/donate ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
