Re: [HACKERS] subselect - Mailing list pgsql-hackers

From Thomas G. Lockhart
Subject Re: [HACKERS] subselect
Date
Msg-id 34B1B803.5DF3DA46@alumni.caltech.edu
Whole thread Raw
In response to Re: [HACKERS] subselect  (Bruce Momjian <maillist@candle.pha.pa.us>)
Responses Re: [HACKERS] subselect  (Bruce Momjian <maillist@candle.pha.pa.us>)
List pgsql-hackers
> BTW, note that for _expression_ subqueries (which are introduced without
> IN, EXISTS, ALL, ANY - this follows Sybase' naming) - as in your examples -
> we have to check that subquery returns single tuple...

It might be nice to have a tuple-counting operation or query node (is this the right
terminology?) which could be used to help implement EXISTS. It might help to
re-implement the count(*) function also.

                                                    - Tom



pgsql-hackers by date:

Previous
From: "Thomas G. Lockhart"
Date:
Subject: Re: [HACKERS] My 2c on adjustable blocksizes
Next
From: "Vadim B. Mikheev"
Date:
Subject: Re: [QUESTIONS] where to find SPI support (and what is the latest version?)