Received: from the-rowan.albatross.co.nz (ns.albatross.co.nz [203.97.5.1]) by hub.org (8.9.3/8.9.3) with ESMTP id UAA32224 for ; Tue, 27 Jul 1999 20:00:05 -0400 (EDT) (envelope-from drew@albatross.co.nz) Received: from zair (drew@zair.csarc.otago.ac.nz [139.80.20.4]) by the-rowan.albatross.co.nz (8.9.1/8.9.1) with SMTP id LAA27449 for ; Wed, 28 Jul 1999 11:51:51 +1200 Message-Id: <4.1.19990728114818.00a36030@pern.csarc.otago.ac.nz> X-Sender: drew@mail.albatross.co.nz X-Mailer: QUALCOMM Windows Eudora Pro Version 4.1 Date: Wed, 28 Jul 1999 11:51:48 +1200 To: pgsql-sql@postgresql.org From: Drew Whittle Subject: WHERE parent IN (0,-1) Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" 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