Re: Re: Functions returning sets

mlw wrote:
>
> Stephan Szabo wrote:
> >
> > (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 don't understand your reasoning. Look at the syntax:
>
> select * from foo where bar = function(...);
>
> If function() returns one value, then only one will be returned and the
> relation features of postgres can be used, as in "select * from foo, this where
> foo.bar = function() and foo.bar = this.that"
>
> If function() can return multiple values, should it not follow that multiple
> values should be selected?

of course not! if function() can return (i.e. returns) as set then bar
must be of
type SET too and only rows that are = (in whatever sense currently
defined) should
be returned

---------------
Hannu