Re: Is this fixed in the 7.4 release? - Mailing list pgsql-interfaces

Wei Weng <wweng@kencast.com> writes:
> Basically, I am asking the program to return me the field type of the 
> first column in the command "select '' AS blah". I was expecting 
> something like a CHAROID, but the return value is UNKNOWNOID (OID(705)). 

> Is this a bug?

No.  There isn't anything in that command that constrains the datatype
of the literal, so its type remains UNKNOWN.
        regards, tom lane