Re: Functions returning sets - Mailing list pgsql-hackers

From Stephan Szabo
Subject Re: Functions returning sets
Date
Msg-id Pine.BSF.4.21.0105191354340.50686-100000@megazone23.bigpanda.com
Whole thread Raw
In response to Functions returning sets  (mlw <markw@mohawksoft.com>)
Responses Re: Functions returning sets  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
(Machine couldn't find mx record for mohawksoft, replying only
to list)

On Sat, 19 May 2001, mlw wrote:

> Sorry to gripe here. Don't get me wrong, I think Postgres is amazing, and I
> think all you guys do an amazing job. 
> 
> Is it just me, or do others agree, functions returning sets need to be able to
> be used in a select where equal clause.
>
> select * from table where field = funct_set('bla bla');

I think what we should probably do is make IN better and use that or then
support =ANY(=SOME)/=ALL on such things.  I think =ANY would be easy
since IN is defined in terms of it in the spec.

I personally don't like the idea of value = set being value in set any
more than value = array being value in array.



pgsql-hackers by date:

Previous
From: mlw
Date:
Subject: Functions returning sets
Next
From: mlw
Date:
Subject: Re: Functions returning sets