Re: [BUGS] PostgresSQL 7.1.3 not parsing SELECT portion of SQL correctly

2002-02-21 Thread Bruce Momjian
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

Re: [BUGS] PostgresSQL 7.1.3 not parsing SELECT portion of SQL correctly

2002-02-01 Thread Tom Lane
"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?