Peter Hoskin <peterh@xxxxxxxxxx> 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
