Re: [HACKERS] subquery syntax broken
Bruce Momjian <maillist@candle.pha.pa.us>
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: lockhart@alumni.caltech.edu (Thomas G. Lockhart)
Cc: vadim@sable.krasnoyarsk.su, hackers@postgresql.org
Date: 1998-02-02T17:12:01Z
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@candle.pha.pa.us