Expression matching related question - Mailing list pgsql-general

From Peter Hoskin
Subject Expression matching related question
Date
Msg-id 44396D25.2080803@criten.org
Whole thread Raw
Responses Re: Expression matching related question  (Peter Hoskin <peterh@criten.org>)
Re: Expression matching related question  (Michael Fuhr <mike@fuhr.org>)
Re: Expression matching related question  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
Hi,

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.

Help would be appreciated.

Regards,
Peter Hoskin

pgsql-general by date:

Previous
From: "Milen Kulev"
Date:
Subject: Re: "Pg_restore -C" is not creating a database ( Was Create database bug in 8.1.3 ? )
Next
From: Martijn van Oosterhout
Date:
Subject: Re: Date & Time with time zone