Re: Functions returning sets

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Functions returning sets
Date: 2001-05-19 21:08:06
Message-ID: Pine.BSF.4.21.0105191354340.50686-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message mlw 2001-05-19 21:42:13 Re: Functions returning sets
Previous Message mlw 2001-05-19 20:35:56 Functions returning sets