diff options
| author | Bruce Momjian <bruce@momjian.us> | 2007-01-11 18:44:53 +0000 |
|---|---|---|
| committer | Bruce Momjian <bruce@momjian.us> | 2007-01-11 18:44:53 +0000 |
| commit | e2fe327013892267f6ebcb9c2acbd79f85626370 (patch) | |
| tree | 156d1b92d34b16e4edb283ea78cd2534a6e3b55b | |
| parent | ad429fe314d3dd42dc3f3e827f4ffad2b121a1ea (diff) | |
| download | postgresql-e2fe327013892267f6ebcb9c2acbd79f85626370.tar.gz | |
Improve error wording of ORDER BY in UNION that uses new expressions in
ORDER BY.
| -rw-r--r-- | src/backend/parser/analyze.c | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/src/backend/parser/analyze.c b/src/backend/parser/analyze.c index f4b566cb6d..8048b63e64 100644 --- a/src/backend/parser/analyze.c +++ b/src/backend/parser/analyze.c @@ -6,7 +6,7 @@ * Portions Copyright (c) 1996-2007, PostgreSQL Global Development Group * Portions Copyright (c) 1994, Regents of the University of California * - * $PostgreSQL: pgsql/src/backend/parser/analyze.c,v 1.355 2007/01/09 02:14:13 tgl Exp $ + * $PostgreSQL: pgsql/src/backend/parser/analyze.c,v 1.356 2007/01/11 18:44:53 momjian Exp $ * *------------------------------------------------------------------------- */ @@ -2547,7 +2547,7 @@ transformSetOperationStmt(ParseState *pstate, SelectStmt *stmt) if (tllen != list_length(qry->targetList)) ereport(ERROR, (errcode(ERRCODE_FEATURE_NOT_SUPPORTED), - errmsg("ORDER BY on a UNION/INTERSECT/EXCEPT result must be on one of the result columns"))); + errmsg("ORDER BY on a UNION/INTERSECT/EXCEPT result must match existing result columns"))); qry->limitOffset = transformLimitClause(pstate, limitOffset, "OFFSET"); |