Re: [GENERAL] Expression matching related question

2006-04-09 Thread Tom Lane
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

Re: [GENERAL] Expression matching related question

2006-04-09 Thread Michael Fuhr
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 > aro

Re: [GENERAL] Expression matching related question

2006-04-09 Thread Peter Hoskin
I should of mentioned, left is a bigint and network is an integer Peter Hoskin wrote: 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 t

[GENERAL] Expression matching related question

2006-04-09 Thread Peter Hoskin
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. H