AW: Three types of functions, ala function redux.

Поиск
Список
Период
Сортировка
От Zeugswetter Andreas SB
Тема AW: Three types of functions, ala function redux.
Дата
Msg-id 11C1E6749A55D411A9670001FA68796336818E@sdexcsrv1.f000.d0188.sd.spardat.at
обсуждение исходный текст
Список 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


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Hannu Krosing
Дата:
Сообщение: Re: Who is a maintainer of GiST code ?
Следующее
От: Zeugswetter Andreas SB
Дата:
Сообщение: AW: PostgreSQL pre-7.1 Linux/Alpha Status...