Re: Simple PG Sql question (i hope)

[Tony Caduto <tony_caduto@xxxxxxxxxxxxxxxxxxxx>]

Hi,
I don't think I was clear enough.

I know about using the AS keyword, that is not the problem.
The query in issue is:

select true,78,'Here is a value' as stringfield, testname from tbltest

Is returning the string as TYPE Unknown, not the column name.  The 
column name comes back as stringfield because of the AS keyword.

You can see the type in tools such as PG Admin etc

Thanks,

Tony

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings