[GENERAL] Inconsistent behavior with unnamed columns

2013-09-30 Thread Moshe Jacobson
Why does bool get special treatment? postgres# select 'abc', 1, false; ?column? | ?column? | bool --+--+-- abc |1 | f (1 row) Moshe Jacobson Nead Werx, Inc. | Manager of Systems Engineering 2323 Cumberland Parkway, Suite 201 | Atlanta, GA 30339

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?

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;* If

Re: [GENERAL] Inconsistent behavior with unnamed columns

2013-09-30 Thread Tom Lane
David Johnston pol...@yahoo.com 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 -