Skip site navigation (1) Skip section navigation (2)

Re: PostgresSQL 7.1.3 not parsing SELECT portion of SQL correctly

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
Cc: pgsql-bugs(at)postgresql(dot)org, "Mark Jeacocke" <mbj(at)ezytools(dot)com>
Subject: Re: PostgresSQL 7.1.3 not parsing SELECT portion of SQL correctly
Date: 2002-02-01 22:53:02
Message-ID: 13528.1012603982@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-bugs
"Mark Jeacocke" <mbj(at)ezytools(dot)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.

In response to

Responses

pgsql-bugs by date

Next:From: Eric ScrogerDate: 2002-02-02 01:08:15
Subject: JDBC- SQLException results returned?
Previous:From: Tom LaneDate: 2002-02-01 22:11:01
Subject: Re: array_dims function is poorly behaved

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group