Re: [HACKERS] subquery syntax broken

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: [HACKERS] subquery syntax broken
Дата
Msg-id 199802021712.MAA13341@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: [HACKERS] subquery syntax broken  ("Thomas G. Lockhart" <lockhart@alumni.caltech.edu>)
Список 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

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] subquery syntax broken
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: [HACKERS] FAQs