Skip site navigation (1) Skip section navigation (2)

pgsql: Implement RETURN QUERY for PL/PgSQL.

From: neilc(at)postgresql(dot)org (Neil Conway)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Implement RETURN QUERY for PL/PgSQL.
Date: 2007-07-25 04:19:09
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-committers
Log Message:
Implement RETURN QUERY for PL/PgSQL. This provides some convenient syntax
sugar for PL/PgSQL set-returning functions that want to return the result
of evaluating a query; it should also be more efficient than repeated
RETURN NEXT statements. Based on an earlier patch from Pavel Stehule.

Modified Files:
        plpgsql.sgml (r1.115 -> r1.116)
        gram.y (r1.104 -> r1.105)
        pl_exec.c (r1.198 -> r1.199)
        pl_funcs.c (r1.62 -> r1.63)
        plpgsql.h (r1.90 -> r1.91)
        scan.l (r1.57 -> r1.58)
        plpgsql.out (r1.57 -> r1.58)
        plpgsql.sql (r1.48 -> r1.49)

pgsql-committers by date

Next:From: Magnus HaganderDate: 2007-07-25 10:17:46
Subject: pgsql: Silence compiler warnings on mingw
Previous:From: Tom LaneDate: 2007-07-24 17:22:13
Subject: pgsql: Fix predicate-proving logic to cope with binary-compatibility

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group