AW: Three types of functions, ala function redux.

From: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>
To: "'mlw'" <markw(at)mohawksoft(dot)com>, Hackers List <pgsql-hackers(at)postgresql(dot)org>
Subject: AW: Three types of functions, ala function redux.
Date: 2000-12-21 09:43:39
Message-ID: 11C1E6749A55D411A9670001FA68796336818E@sdexcsrv1.f000.d0188.sd.spardat.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers


> select * from table where col = function() ;

> (2) "function()" returns a number of values that are independent of the
> query. Postgres should be able to optimize this to be: "select * from
> table where col in (val1, val2, val3, ..valn)." I guess Postgres can
> loop until done, using the isDone flag?

I think the above needs a different sql statement to begin with.
The "= function()" clearly states that function is only allowed to return one row.

The following syntax currently works, and is imho sufficient:
select * from table where col in (select function());

Andreas

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Zeugswetter Andreas SB 2000-12-21 10:53:11 AW: PostgreSQL pre-7.1 Linux/Alpha Status...
Previous Message Hannu Krosing 2000-12-21 09:12:41 Re: Who is a maintainer of GiST code ?