Re: [HACKERS] Re: subselects
Thomas Lockhart <lockhart@alumni.caltech.edu>
From: "Thomas G. Lockhart" <lockhart@alumni.caltech.edu>
To: "Vadim B. Mikheev" <vadim@sable.krasnoyarsk.su>
Cc: Bruce Momjian <maillist@candle.pha.pa.us>, hackers@postgresql.org
Date: 1998-01-10T19:55:08Z
Lists: pgsql-hackers
Attachments
- gram.y (text/plain)
- keywords.c (text/plain)
> I would like to have something done in parser near Jan 17 to get
> subqueries working by Feb 1.
Here are some changes to gram.y and to keywords.c which start to pass through
subselect constructs. I won't commit until/unless you have a chance to look at it and
agree that this is something close to the right direction to head.
- Tom
postgres=> create table x (i int);
CREATE
postgres=> insert into x values (1);
INSERT 18121 1
postgres=> select i from x where i = 1;
i
-
1
(1 row)
postgres=> select i from x where i in (select i from x);
ERROR: transformExpr: does not know how to transform node 604
postgres=> select i from x where (i, 1) in (select i, 1 from x);
ERROR: transformExpr: does not know how to transform node 501
postgres=>