plpsm - plpgpsm: table expression this patch allows table expression in

Поиск
Список
Период
Сортировка
От okbob@pgfoundry.org (User Okbob)
Тема plpsm - plpgpsm: table expression this patch allows table expression in
Дата
Msg-id 20070205175752.8AF17217280@pgfoundry.org
обсуждение исходный текст
Список pgsql-committers
Log Message:
-----------
table expression

this patch allows table expression in SRF functions. Allow SELECT statement
as argument of RETURN statement or SELECT (everything which returns table)
as one statement's body.

See:
CREATE OR REPLACE FUNCTION fx(a int)
RETURNS SETOF RECORD AS
$$
  RETURN SELECT *
            FROM Foo
           WHERE fx.a = Foo.a;
$$ LANGUAGE plpgpsm;

CREATE OR REPLACE fx2(a int)
RETURNS SETOF RECORD AS
$$
  SELECT *
     FROM Foo
   WHERE fx.a = Foo.a;
$$ LANGUAGE plpgpsm;

Modified Files:
--------------
    plpgpsm/src:
        gram.y (r1.33 -> r1.34)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/plpsm/plpgpsm/src/gram.y.diff?r1=1.33&r2=1.34)
        pl_comp.c (r1.11 -> r1.12)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/plpsm/plpgpsm/src/pl_comp.c.diff?r1=1.11&r2=1.12)
        pl_exec.c (r1.35 -> r1.36)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/plpsm/plpgpsm/src/pl_exec.c.diff?r1=1.35&r2=1.36)
        plpgpsm.h (r1.24 -> r1.25)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/plpsm/plpgpsm/src/plpgpsm.h.diff?r1=1.24&r2=1.25)
        scan.l (r1.9 -> r1.10)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/plpsm/plpgpsm/src/scan.l.diff?r1=1.9&r2=1.10)
    plpgpsm/src/expected:
        plpgpsm.out (r1.9 -> r1.10)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/plpsm/plpgpsm/src/expected/plpgpsm.out.diff?r1=1.9&r2=1.10)
    plpgpsm/src/sql:
        plpgpsm.sql (r1.8 -> r1.9)
        (http://cvs.pgfoundry.org/cgi-bin/cvsweb.cgi/plpsm/plpgpsm/src/sql/plpgpsm.sql.diff?r1=1.8&r2=1.9)

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

Предыдущее
От: momjian@postgresql.org (Bruce Momjian)
Дата:
Сообщение: pgsql: Updated TODO item: > o Add a \set variable to control whether
Следующее
От: okbob@pgfoundry.org (User Okbob)
Дата:
Сообщение: plpsm - plpgpsm: add check which protect combination of return table