Functions as first-class values

Поиск
Список
Период
Сортировка
От Jon Smark
Тема Functions as first-class values
Дата
Msg-id 961874.23865.qm@web112804.mail.gq1.yahoo.com
обсуждение исходный текст
Ответы Re: Functions as first-class values
Список pgsql-general
Hi,

Is there support in PL/pgSQL for treating functions as first-class values?
Consider the pseudo-code simple example below, which illustrates how this
feature can be useful.  I reckon that this behaviour can be emulated using
EXECUTE, but I suspect there are serious performance penalties.
Your thoughts?

Thanks in advance!
Jon


CREATE FUNCTION f1 (int) RETURNS boolean ...
CREATE FUNCTION f2 (int) RETURNS boolean ...
CREATE FUNCTION f3 (int) RETURNS boolean ...

CREATE FUNCTION do_stuff ...
BEGIN
        CASE cond
                WHEN 'a' THEN func := f1;
                WHEN 'b' THEN func := f2;
                WHEN 'c' THEN func := f3;
        END CASE

        SELECT * FROM foobar WHERE func (foobar.age);
END;


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

Предыдущее
От: tv@fuzzy.cz
Дата:
Сообщение: Re: Critical Bug
Следующее
От: Andrew Sullivan
Дата:
Сообщение: Re: forums.postgresql.com.au