Thread

Re: [HACKERS] Open 6.5 items

Keith Parks <emkxp01@mtcc.demon.co.uk> — 1999-06-03T22:30:42Z

Bruce Momjian <maillist@candle.pha.pa.us>
> 

What's this item? Do we have anything more specific?

> SELECT * FROM test WHERE test IN (SELECT * FROM test) fails with strange error

postgres=> drop table test;
DROP
postgres=> create table test ( test int );
CREATE
postgres=> insert into test values ( 3);
INSERT 148950 1
postgres=> insert into test values ( 2);
INSERT 148951 1
postgres=> insert into test values ( 1);
INSERT 148952 1
postgres=> SELECT * FROM test WHERE test IN (SELECT * FROM test);
test
----
   3
   2
   1
(3 rows)

postgres=>

Looks OK to me.

Keith.