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@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