Wei Weng <wweng(at)kencast(dot)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