Re: Functions returning sets

(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.