Re: Inconsistent behavior with unnamed columns

On 09/30/2013 01:48 PM, Moshe Jacobson wrote:
> Why does bool get special treatment?
>
> |postgres# select 'abc', 1, false;
> ?column? | ?column? | bool
> ----------+----------+------
> abc | 1 | f
> (1 row)|

Not always:

test=> select 'abc'::text, 1::int, 'f';
text | int4 | ?column?
------+------+----------
abc | 1 | f

>
> Moshe Jacobson
> Nead Werx, Inc. | Manager of Systems Engineering
> 2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339
> moshe(at)neadwerx(dot)com <mailto:moshe(at)neadwerx(dot)com> | www.neadwerx.com
> <http://www.neadwerx.com/>
>
> “Quality is not an act, it is a habit.” — Aristotle
>

--
Adrian Klaver
adrian(dot)klaver(at)gmail(dot)com