Re: [HACKERS] subselect

From: "Thomas G(dot) Lockhart" <lockhart(at)alumni(dot)caltech(dot)edu>
To: "Vadim B(dot) Mikheev" <vadim(at)sable(dot)krasnoyarsk(dot)su>
Cc: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>, hackers(at)postgresql(dot)org
Subject: Re: [HACKERS] subselect
Date: 1998-01-06 04:50:12
Message-ID: 34B1B803.5DF3DA46@alumni.caltech.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 1998-01-06 05:06:39 Re: [HACKERS] subselect
Previous Message Thomas G. Lockhart 1998-01-06 04:43:26 Re: [HACKERS] My 2c on adjustable blocksizes