Postgres Pro
Downloads
Home   >   mailing lists

Re: PostgresSQL 7.1.3 not parsing SELECT portion of SQL correctly - Mailing list pgsql-bugs

From Tom Lane
Subject Re: PostgresSQL 7.1.3 not parsing SELECT portion of SQL correctly
Date
Msg-id 13528.1012603982@sss.pgh.pa.us
Whole thread Raw
In response to PostgresSQL 7.1.3 not parsing SELECT portion of SQL correctly  ("Mark Jeacocke" <mbj@ezytools.com>)
Responses Re: PostgresSQL 7.1.3 not parsing SELECT portion of SQL correctly  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-bugs
Tree view 
"Mark Jeacocke" <mbj@ezytools.com> writes:
> select DISTINCT TABLEID, '' AS ALIAS from TABLE; :FAILS

We get this type of complaint regularly.  Perhaps DISTINCT should
resolve unknown-type inputs to "text", much as we do with CASE
and UNION constructs when we see an untyped literal.  Thoughts?

            regards, tom lane

PS: in the meantime, Mark, try casting the literal to text.

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: array_dims function is poorly behaved
Next
From: Eric Scroger
Date:
Subject: JDBC- SQLException results returned?