Re: [SQL] WHERE parent IN (0,-1)

> 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026