WHERE parent IN (0,-1) - Mailing list pgsql-sql

From Drew Whittle
Subject WHERE parent IN (0,-1)
Date
Msg-id 4.1.19990728114818.00a36030@pern.csarc.otago.ac.nz
Whole thread Raw
Responses Re: [SQL] WHERE parent IN (0,-1)  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-sql
Hi,

I'm pretty new to Postgres, so please excuse my ignorance.

I have a sql script that uses WHERE parent IN (0,-1), this works fine with
MySQL, Access, & MS-SQL Server, unfortunately Postgres does not like this
statement, I can get around the problem (I think) by using WHERE parent IN
(0,'-1'). 

Is this valid? 

Is there another way to do this that works with Postgres and the others?
(They dont like the ' around -1)

Thanks,

Drew



pgsql-sql by date:

Previous
From: Jens Glaser
Date:
Subject: Outer Joins, Foreign keys, subselects
Next
From: Bruce Momjian
Date:
Subject: Re: [SQL] WHERE parent IN (0,-1)