Re: Simple PG Sql question (i hope)

Tony Caduto wrote:
> 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?

Because it doesn't know what you want it as :) For example in 8.0.3:


template1=# select true,78,'Here is a value' as stringfield;
  bool | ?column? |   stringfield
------+----------+-----------------
  t    |       78 | Here is a value
(1 row)

Or

template1=# select true,78::int4,'Here is a value'::text as stringfield;
  bool | int4 |   stringfield
------+------+-----------------
  t    |   78 | Here is a value
(1 row)


Sincerely,

Joshua D. Drake


> 
> 
> 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


-- 
Your PostgreSQL solutions company - Command Prompt, Inc. 1.800.492.2240
PostgreSQL Replication, Consulting, Custom Programming, 24x7 support
Managed Services, Shared and Dedicated Hosting
Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/