Search Postgresql Archives
curiosity in default column header
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
- Subject: curiosity in default column header
- From: Rob Sargent <robjsargent@xxxxxxxxx>
- Date: Fri, 24 Feb 2023 13:47:44 -0700
- User-agent: Mozilla/5.0 (X11; Linux x86_64; rv:102.0) Gecko/20100101 Thunderbird/102.7.1
riftehr=> select
ascii(substring('sadb', 2,1));
ascii
-------
97
(1 row)
riftehr=> select 24::bit(8);
bit
----------
00011000
(1 row)
riftehr=> select ascii(substring('sadb', 2,1))::bit(8);
ascii
----------
01100001
(1 row)
Why is the last one headed "ascii" and not "bit"?
[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 Databases]
[Postgresql & PHP]
[Yosemite]