On Mon, Apr 10, 2006 at 06:23:01AM +1000, Peter Hoskin wrote:
> 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.
If you're using reserved words like table, column, and left as
identifiers then you'll need to double-quote them. Better yet,
avoid using reserved words as identifiers.
--
Michael Fuhr