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.


Thu, 3 Jun 1999 23:30:42 +0100 (BST)
Keith Parks <emkxp01@mtcc.demon.co.uk>
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, Pennsylvania 19026

Fri, 4 Jun 1999 10:15:31 -0400 (EDT)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: [HACKERS] Open 6.5 items