Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-hackers by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group