pgsql: Implement SQL-spec RETURNS TABLE syntax for functions. - Mailing list pgsql-committers

From tgl@postgresql.org (Tom Lane)
Subject pgsql: Implement SQL-spec RETURNS TABLE syntax for functions.
Date
Msg-id 20080718033253.CF1B0754A84@cvs.postgresql.org
Whole thread Raw
List pgsql-committers
Log Message:
-----------
Implement SQL-spec RETURNS TABLE syntax for functions.

(Unlike the original submission, this patch treats TABLE output parameters
as being entirely equivalent to OUT parameters -- tgl)

Pavel Stehule

Modified Files:
--------------
    pgsql/doc/src/sgml:
        catalogs.sgml (r2.170 -> r2.171)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/catalogs.sgml?r1=2.170&r2=2.171)
        func.sgml (r1.441 -> r1.442)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/func.sgml?r1=1.441&r2=1.442)
        plpgsql.sgml (r1.132 -> r1.133)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/plpgsql.sgml?r1=1.132&r2=1.133)
        xfunc.sgml (r1.131 -> r1.132)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/xfunc.sgml?r1=1.131&r2=1.132)
    pgsql/doc/src/sgml/ref:
        create_function.sgml (r1.79 -> r1.80)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/doc/src/sgml/ref/create_function.sgml?r1=1.79&r2=1.80)
    pgsql/src/backend/catalog:
        information_schema.sql (r1.44 -> r1.45)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/information_schema.sql?r1=1.44&r2=1.45)
        pg_proc.c (r1.152 -> r1.153)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/catalog/pg_proc.c?r1=1.152&r2=1.153)
    pgsql/src/backend/commands:
        functioncmds.c (r1.97 -> r1.98)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/commands/functioncmds.c?r1=1.97&r2=1.98)
    pgsql/src/backend/parser:
        gram.y (r2.617 -> r2.618)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/parser/gram.y?r1=2.617&r2=2.618)
    pgsql/src/backend/utils/adt:
        ruleutils.c (r1.277 -> r1.278)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/ruleutils.c?r1=1.277&r2=1.278)
    pgsql/src/backend/utils/fmgr:
        funcapi.c (r1.40 -> r1.41)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/fmgr/funcapi.c?r1=1.40&r2=1.41)
    pgsql/src/bin/pg_dump:
        pg_dump.c (r1.495 -> r1.496)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/pg_dump/pg_dump.c?r1=1.495&r2=1.496)
    pgsql/src/bin/psql:
        describe.c (r1.182 -> r1.183)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/bin/psql/describe.c?r1=1.182&r2=1.183)
    pgsql/src/include/catalog:
        catversion.h (r1.470 -> r1.471)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/catversion.h?r1=1.470&r2=1.471)
        pg_proc.h (r1.508 -> r1.509)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/catalog/pg_proc.h?r1=1.508&r2=1.509)
    pgsql/src/include/nodes:
        parsenodes.h (r1.367 -> r1.368)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/nodes/parsenodes.h?r1=1.367&r2=1.368)
    pgsql/src/include/utils:
        builtins.h (r1.318 -> r1.319)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/include/utils/builtins.h?r1=1.318&r2=1.319)
    pgsql/src/pl/plpgsql/src:
        pl_comp.c (r1.127 -> r1.128)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/pl/plpgsql/src/pl_comp.c?r1=1.127&r2=1.128)
    pgsql/src/pl/plpython:
        plpython.c (r1.111 -> r1.112)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/pl/plpython/plpython.c?r1=1.111&r2=1.112)
    pgsql/src/test/regress/expected:
        plpgsql.out (r1.65 -> r1.66)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/plpgsql.out?r1=1.65&r2=1.66)
        rangefuncs.out (r1.17 -> r1.18)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/expected/rangefuncs.out?r1=1.17&r2=1.18)
    pgsql/src/test/regress/sql:
        plpgsql.sql (r1.55 -> r1.56)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/plpgsql.sql?r1=1.55&r2=1.56)
        rangefuncs.sql (r1.7 -> r1.8)
        (http://anoncvs.postgresql.org/cvsweb.cgi/pgsql/src/test/regress/sql/rangefuncs.sql?r1=1.7&r2=1.8)

pgsql-committers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: pgsql: Allow TRUNCATE foo, foo to succeed, per report from Nikhils.
Next
From: Tom Lane
Date:
Subject: Re: pgsql: Support "variadic" functions, which can accept a variable number