Simple PG Sql question (i hope) - Mailing list pgsql-general

From Tony Caduto
Subject Simple PG Sql question (i hope)
Date
Msg-id 42F7AD2C.2060903@amsoftwaredesign.com
Whole thread Raw
In response to Updating timestamps  (Nigel Horne <njh@bandsman.co.uk>)
Responses AMD 64 RPM?
Re: Simple PG Sql question (i hope)
List pgsql-general
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

pgsql-general by date:

Previous
From: Jeff Davis
Date:
Subject: escape string type for upcoming 8.1
Next
From: Tony Caduto
Date:
Subject: AMD 64 RPM?