Postgres Pro
Downloads
Home   >   mailing lists

Re: AW: [HACKERS] "internal error" triggered by EXISTS() - Mailing list pgsql-hackers

From Vadim Mikheev
Subject Re: AW: [HACKERS] "internal error" triggered by EXISTS()
Date
Msg-id 35ACECA5.AB5DA1F6@krs.ru
Whole thread Raw
In response to AW: [HACKERS] "internal error" triggered by EXISTS()  (Andreas Zeugswetter <andreas.zeugswetter@telecom.at>)
List pgsql-hackers
Tree view 
Andreas Zeugswetter wrote:
>
> >>
> >> We only support subqueries in the target list.  May have that expaned
> >> for 6.4.
> >
> >Not sure that EXISTS is allowed in target list...
>
> The standard does not allow it, but it might be a nifty feature if
> it returned a boolean true or false.

I don't foresee problems with this.
BTW, shouldn't we allow the same for IN, ANY and ALL?

select ..., x in (...), ...

Vadim

pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Recent updates
Next
From: Tom Lane
Date:
Subject: Current sources dump core on COPY IN/OUT