|
6 | 6 | * Portions Copyright (c) 1996-2007, PostgreSQL Global Development Group |
7 | 7 | * Portions Copyright (c) 1994, Regents of the University of California |
8 | 8 | * |
9 | | - *$PostgreSQL: pgsql/src/backend/parser/analyze.c,v 1.356 2007/01/1118:44:53 momjian Exp $ |
| 9 | + *$PostgreSQL: pgsql/src/backend/parser/analyze.c,v 1.357 2007/01/1120:04:50 momjian Exp $ |
10 | 10 | * |
11 | 11 | *------------------------------------------------------------------------- |
12 | 12 | */ |
@@ -2547,7 +2547,7 @@ transformSetOperationStmt(ParseState *pstate, SelectStmt *stmt) |
2547 | 2547 | if (tllen!=list_length(qry->targetList)) |
2548 | 2548 | ereport(ERROR, |
2549 | 2549 | (errcode(ERRCODE_FEATURE_NOT_SUPPORTED), |
2550 | | -errmsg("ORDER BY on aUNION/INTERSECT/EXCEPTresult must match existingresultcolumns"))); |
| 2550 | +errmsg("AUNION/INTERSECT/EXCEPTORDER BY cannot use expressions or functions, onlyresultcolumn names"))); |
2551 | 2551 |
|
2552 | 2552 | qry->limitOffset=transformLimitClause(pstate,limitOffset, |
2553 | 2553 | "OFFSET"); |
|