Thread

Re: [HACKERS] Re: subselects

Thomas Lockhart <lockhart@alumni.caltech.edu> — 1998-01-10T19:55:08Z

> 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=>