"Mark Jeacocke" <[EMAIL PROTECTED]> 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.
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
