diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2008-10-31 19:37:56 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2008-10-31 19:37:56 +0000 |
| commit | 9b46abb7c47de8aa408a8c83666fd67c5447eb85 (patch) | |
| tree | 034991f27008de03ff71f505431b10a1b2ae5e5e /src/include/tcop | |
| parent | cd97f98844b5640b1cdc701c691c962155dce3b4 (diff) | |
| download | postgresql-9b46abb7c47de8aa408a8c83666fd67c5447eb85.tar.gz | |
Allow SQL-language functions to return the output of an INSERT/UPDATE/DELETE
RETURNING clause, not just a SELECT as formerly.
A side effect of this patch is that when a set-returning SQL function is used
in a FROM clause, performance is improved because the output is collected into
a tuplestore within the function, rather than using the less efficient
value-per-call mechanism.
Diffstat (limited to 'src/include/tcop')
| -rw-r--r-- | src/include/tcop/dest.h | 5 |
1 files changed, 3 insertions, 2 deletions
diff --git a/src/include/tcop/dest.h b/src/include/tcop/dest.h index 7484b84f76..5522f78c68 100644 --- a/src/include/tcop/dest.h +++ b/src/include/tcop/dest.h @@ -54,7 +54,7 @@ * Portions Copyright (c) 1996-2008, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $PostgreSQL: pgsql/src/include/tcop/dest.h,v 1.54 2008/01/01 19:45:59 momjian Exp $ + * $PostgreSQL: pgsql/src/include/tcop/dest.h,v 1.55 2008/10/31 19:37:56 tgl Exp $ * *------------------------------------------------------------------------- */ @@ -86,7 +86,8 @@ typedef enum DestSPI, /* results sent to SPI manager */ DestTuplestore, /* results sent to Tuplestore */ DestIntoRel, /* results sent to relation (SELECT INTO) */ - DestCopyOut /* results sent to COPY TO code */ + DestCopyOut, /* results sent to COPY TO code */ + DestSQLFunction /* results sent to SQL-language func mgr */ } CommandDest; /* ---------------- |