> 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 );
Try this:
create table test(x 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.
>
>
-- 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