From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | lockhart(at)alumni(dot)caltech(dot)edu (Thomas G(dot) Lockhart) |
Cc: | vadim(at)sable(dot)krasnoyarsk(dot)su, hackers(at)postgresql(dot)org |
Subject: | Re: [HACKERS] subquery syntax broken |
Date: | 1998-02-02 17:12:01 |
Message-ID: | 199802021712.MAA13341@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
>
> > Tom, Bruce - could you take care about this ?
>
> Bruce? Let me know if you want me to look at it. I didn't include this
> syntax originally since I thought singleton results like aggregates would
> certainly not be implemented in the first cut. Forgot about Vadim's
> prodigious talents :)
It's not the aggregates, it is the whole '= (subquery)' that is missing
from gram.y. I am adding it now.
test=> select * from pg_user where usesysid = (select usesysid from
pg_user);
ERROR: parser: syntax error at or near "select"
>
> > (BTW, I fixed parse_expr.c broken for EXISTS...)
> > I'm going home now and will be here ~ 2 Feb 20:00 (PST). Hope to include
> > subselect code into CVS in the next 24 hrs (from now)...
> >
> > Also, could someone take care about data/queries for regression tests ?
> > (May be by using "big boys"...)
>
> Yes, we should add a "subselect.sql" regression test. Anyone taking a first
> cut?
>
> - Tom
>
>
--
Bruce Momjian
maillist(at)candle(dot)pha(dot)pa(dot)us
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1998-02-02 17:13:04 | Re: [HACKERS] Variable block size... |
Previous Message | Bruce Momjian | 1998-02-02 17:09:26 | Re: [HACKERS] FAQs |