"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
pgsql-bugs by date
|Next:||From: Eric Scroger||Date: 2002-02-02 01:08:15|
|Subject: JDBC- SQLException results returned?|
|Previous:||From: Tom Lane||Date: 2002-02-01 22:11:01|
|Subject: Re: array_dims function is poorly behaved |