Peter Hoskin <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings