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.