WHERE parent IN (0,-1)

From: Drew Whittle <drew(at)albatross(dot)co(dot)nz>
To: pgsql-sql(at)postgresql(dot)org
Subject: WHERE parent IN (0,-1)
Date: 1999-07-27 23:51:48
Message-ID: 4.1.19990728114818.00a36030@pern.csarc.otago.ac.nz
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 1999-07-28 00:09:07 Re: [SQL] WHERE parent IN (0,-1)
Previous Message Herouth Maoz 1999-07-27 14:36:09 Re: [INTERFACES] How can I work thru this key problem?