Re: [HACKERS] Open 6.5 items

> Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026