> 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
>
>
>
yes, that's a good workaround. Added to TODO list:
* select * from pg_class where oid in (0,-1);
-- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610)
853-3000+ If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill,
Pennsylvania19026