aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
authorBruce Momjian <bruce@momjian.us>2007-01-11 20:04:50 +0000
committerBruce Momjian <bruce@momjian.us>2007-01-11 20:04:50 +0000
commit87f6d64149bbd1f0ae129f20576efbda4503c521 (patch)
tree4c80a9f322bfd1c8d8ffa7e1d1249eb9ba853283
parente2fe327013892267f6ebcb9c2acbd79f85626370 (diff)
downloadpostgresql-87f6d64149bbd1f0ae129f20576efbda4503c521.tar.gz
postgresql-87f6d64149bbd1f0ae129f20576efbda4503c521.zip
Update UNION/INTERSECT/EXCEPT ORDER BY error wording for
expressions/functions.
-rw-r--r--src/backend/parser/analyze.c4
1 files changed, 2 insertions, 2 deletions
diff --git a/src/backend/parser/analyze.c b/src/backend/parser/analyze.c
index 8048b63e64a..d4f8379115b 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.356 2007/01/11 18:44:53 momjian Exp $
+ * $PostgreSQL: pgsql/src/backend/parser/analyze.c,v 1.357 2007/01/11 20:04:50 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 match existing result columns")));
+ errmsg("A UNION/INTERSECT/EXCEPT ORDER BY cannot use expressions or functions, only result column names")));
qry->limitOffset = transformLimitClause(pstate, limitOffset,
"OFFSET");