I don't have PostrgreSQL installed, but the docs say IN requires a subquery.
http://www.postgresql.org/docs/8.2/interactive/functions-subquery.html MySQL does not support this syntax either (that one I tested). Sam ------------------------------------------- We're Hiring! Seeking a passionate developer to join our team building Flex based products. Position is in the Washington D.C. metro area. If interested contact [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, January 28, 2008 9:20 AM To: sqlite-users@sqlite.org Subject: Re: [sqlite] Number of elements in IN clause "Samuel R. Neff" <[EMAIL PROTECTED]> wrote: > I don't think it is standard SQL. At the very least, it doesn't work in > MSSQL. Standard is > > SELECT * FROM maintable WHERE key IN (select x from stuff); > > SQLite shortened version is much nicer.. wish it was standard. > SQLite also accepts the more verbose version shown above, of course. The two statements do *exactly* the same thing. I cannot believe that I would have put in the short-hand notation without having seen it somewhere else first. Does PostgreSQL support the short-hand version? -- D. Richard Hipp <[EMAIL PROTECTED]> ---------------------------------------------------------------------------- - To unsubscribe, send email to [EMAIL PROTECTED] ---------------------------------------------------------------------------- - ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------