Skip site navigation (1) Skip section navigation (2)

Re: AW: [HACKERS] "internal error" triggered by EXISTS()

From: Vadim Mikheev <vadim(at)krs(dot)ru>
To: Andreas Zeugswetter <andreas(dot)zeugswetter(at)telecom(dot)at>
Cc: "pgsql-hackers(at)hub(dot)org" <pgsql-hackers(at)hub(dot)org>
Subject: Re: AW: [HACKERS] "internal error" triggered by EXISTS()
Date: 1998-07-15 17:53:41
Message-ID: 35ACECA5.AB5DA1F6@krs.ru (view raw or flat)
Thread:
Lists: pgsql-hackers
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

In response to

pgsql-hackers by date

Next:From: Tom LaneDate: 1998-07-15 18:41:26
Subject: Current sources dump core on COPY IN/OUT
Previous:From: Thomas G. LockhartDate: 1998-07-15 17:06:42
Subject: Re: Recent updates

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group