Postgres Pro
Downloads
Home   >   mailing lists

Re: Re: Does PostgreSQL support EXISTS? - Mailing list pgsql-general

From Tom Lane
Subject Re: Re: Does PostgreSQL support EXISTS?
Date
Msg-id 26668.992447426@sss.pgh.pa.us
Whole thread Raw
In response to Re: Re: Does PostgreSQL support EXISTS?  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Re: Does PostgreSQL support EXISTS?  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-general
Tree view 
Bruce Momjian <pgman@candle.pha.pa.us> writes:
> Are we anywhere with optimizing IN to EXISTS?  I didn't think there was
> any work being done in that area.

I don't think it's that hard to do within the outer-join mechanism,
except for this little issue about NULLs.  The planner already makes
querytree alterations of comparable complexity, to deal with views and
subselects...

            regards, tom lane

pgsql-general by date:

Previous
From: BELLON Michel
Date:
Subject: Compilation of contrib of postgresql 7.1.2 with cygwin 1.3.2
Next
From: Tom Lane
Date:
Subject: Re: 7.1.2 temporary file area