pgsql-server/src backend/optimizer/plan/create ... - Mailing list pgsql-committers

CVSROOT:    /cvsroot
Module name:    pgsql-server
Changes by:    tgl@svr1.postgresql.org    03/06/15 23:03:38

Modified files:
    src/backend/optimizer/plan: createplan.c planner.c
    src/backend/optimizer/prep: prepunion.c
    src/backend/parser: analyze.c parse_clause.c
    src/include/parser: parse_clause.h

Log message:
    Allow GROUP BY, ORDER BY, DISTINCT targets to be unknown literals,
    silently resolving them to type TEXT.  This is comparable to what we
    do when faced with UNKNOWN in CASE, UNION, and other contexts.  It gets
    rid of this and related annoyances:
    select distinct f1, '' from int4_tbl;
    ERROR:  Unable to identify an ordering operator '<' for type unknown
    This was discussed many moons ago, but no one got round to fixing it.