Re: [HACKERS] Open 6.5 items

> 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