Peter Hoskin <peterh@criten.org> writes:
> I wish to do a query such as:
> SELECT * FROM table WHERE column='something' AND column2='something
> else' AND (network='0' OR (left=0 AND network>0));
> However, when I execute this in phppgadmin I'm told there is an error
> around the = character in left=0. Can't seem to figure the syntax.
LEFT is a reserved word, isn't it? If you're going to insist on naming
a column "left", you'll have to double-quote the name every time.
regards, tom lane