Expression matching related question

From: Peter Hoskin <peterh(at)criten(dot)org>
To: pgsql-general(at)postgresql(dot)org
Subject: Expression matching related question
Date: 2006-04-09 20:23:01
Message-ID: 44396D25.2080803@criten.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-04-09 20:32:29 Re: Date & Time with time zone
Previous Message Wei Wei 2006-04-09 20:07:50 Date & Time with time zone