diff options
| author | Joe Conway <mail@joeconway.com> | 2006-08-02 01:59:48 +0000 |
|---|---|---|
| committer | Joe Conway <mail@joeconway.com> | 2006-08-02 01:59:48 +0000 |
| commit | 9caafda579f699b43fa4c89bf13a2331ef00611e (patch) | |
| tree | 330423c4be56ffaacb2d028153706f0c213c0aec /src/backend/commands/explain.c | |
| parent | d307c428cbb7c426e40163d234d993e644bbcc6b (diff) | |
| download | postgresql-9caafda579f699b43fa4c89bf13a2331ef00611e.tar.gz postgresql-9caafda579f699b43fa4c89bf13a2331ef00611e.zip | |
Add support for multi-row VALUES clauses as part of INSERT statements
(e.g. "INSERT ... VALUES (...), (...), ...") and elsewhere as allowed
by the spec. (e.g. similar to a FROM clause subselect). initdb required.
Joe Conway and Tom Lane.
Diffstat (limited to 'src/backend/commands/explain.c')
| -rw-r--r-- | src/backend/commands/explain.c | 22 |
1 files changed, 21 insertions, 1 deletions
diff --git a/src/backend/commands/explain.c b/src/backend/commands/explain.c index 7c50784abad..5787aa413e7 100644 --- a/src/backend/commands/explain.c +++ b/src/backend/commands/explain.c @@ -7,7 +7,7 @@ * Portions Copyright (c) 1994-5, Regents of the University of California * * IDENTIFICATION - * $PostgreSQL: pgsql/src/backend/commands/explain.c,v 1.149 2006/07/14 14:52:18 momjian Exp $ + * $PostgreSQL: pgsql/src/backend/commands/explain.c,v 1.150 2006/08/02 01:59:45 joe Exp $ * *------------------------------------------------------------------------- */ @@ -527,6 +527,9 @@ explain_outNode(StringInfo str, case T_FunctionScan: pname = "Function Scan"; break; + case T_ValuesScan: + pname = "Values Scan"; + break; case T_Material: pname = "Materialize"; break; @@ -666,6 +669,22 @@ explain_outNode(StringInfo str, quote_identifier(rte->eref->aliasname)); } break; + case T_ValuesScan: + if (((Scan *) plan)->scanrelid > 0) + { + RangeTblEntry *rte = rt_fetch(((Scan *) plan)->scanrelid, + es->rtable); + char *valsname; + + /* Assert it's on a values rte */ + Assert(rte->rtekind == RTE_VALUES); + + valsname = rte->eref->aliasname; + + appendStringInfo(str, " on %s", + quote_identifier(valsname)); + } + break; default: break; } @@ -728,6 +747,7 @@ explain_outNode(StringInfo str, case T_SeqScan: case T_SubqueryScan: case T_FunctionScan: + case T_ValuesScan: show_scan_qual(plan->qual, "Filter", ((Scan *) plan)->scanrelid, |