Search Postgresql Archives

Re: Inconsistent behavior with unnamed columns

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxx <mailto:moshe@xxxxxxxxxxxx> | www.neadwerx.com
<http://www.neadwerx.com/>

“Quality is not an act, it is a habit.” — Aristotle



--
Adrian Klaver
adrian.klaver@xxxxxxxxx


--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux