Thread: pgsql/src/backend/parser analyze.c

pgsql/src/backend/parser analyze.c

From

Tom Lane

Date:

14 February 2001, 23:10:33

CVSROOT:    /home/projects/pgsql/cvsroot
Module name:    pgsql
Changes by:    tgl@hub.org    01/02/14 20:10:28

Modified files:
    src/backend/parser: analyze.c

Log message:
    Arrange for ORDER BY an expression on a UNION/INTERSECT/EXCEPT result,
    such as
    SELECT f1 FROM foo UNION SELECT ... ORDER BY upper(f1)
    to draw
    'ORDER BY on a UNION/INTERSECT/EXCEPT result must be on one of the result columns'
    rather than the uninformative 'f1 not found' we were producing before.
    Eventually this should actually work, but that looks much too hard to try
    to implement in late beta...