Re: [GENERAL] Inconsistent behavior with unnamed columns

2013-09-30 Thread Tom Lane
David Johnston writes: > Moshe Jacobson wrote >> Why does bool get special treatment? >> >> postgres# select 'abc', 1, false; >> ?column? | ?column? | bool >> --+--+-- >> abc |1 | f >> (1 row) > It doesn't (at least not as I see things in my client/version - note

Re: [GENERAL] Inconsistent behavior with unnamed columns

2013-09-30 Thread David Johnston
Moshe Jacobson wrote > Why does bool get special treatment? > > postgres# select 'abc', 1, false; > ?column? | ?column? | bool > --+--+-- > abc |1 | f > (1 row) It doesn't (at least not as I see things in my client/version - noted below): *SELECT 'abc'::text;*

Re: [GENERAL] Inconsistent behavior with unnamed columns

2013-09-30 Thread Adrian Klaver
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? -