| From: | "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu> |
|---|---|
| To: | "Vadim B(dot) Mikheev" <vadim(at)sable(dot)krasnoyarsk(dot)su> |
| Cc: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, hackers(at)postgresql(dot)org |
| Subject: | Re: [HACKERS] Re: subselects |
| Date: | 1998-01-10 19:55:08 |
| Message-ID: | 34B7D21C.57EAFF12@alumni.caltech.edu |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
> 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=>
| Attachment | Content-Type | Size |
|---|---|---|
| gram.y | text/plain | 100.1 KB |
| keywords.c | text/plain | 5.4 KB |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Edmund Mergl | 1998-01-10 20:01:27 | Re: [HACKERS] DefaultHost |
| Previous Message | Thomas G. Lockhart | 1998-01-10 19:31:29 | Re: [HACKERS] Re: subselects |