I have a simple query:
select true,78,'Here is a value' as stringfield, testname from tbltest;
it returns:
true as bool
78 as int4
and the string 'Here is a value' as Unknown
Why is it that all the values besides the string come back with the
correct type?
what is a simple string being returned as unknown instead of varchar or
text?
Thanks,
Tony
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
