Is this a TODO item? Seems so. Comments?
--------------------------------------------------------------------------- Tom Lane wrote: > "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 > -- Bruce Momjian | http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026 ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly
