Postgres Pro
Downloads
Home   >   mailing lists

curiosity in default column header - Mailing list pgsql-general

From Rob Sargent
Subject curiosity in default column header
Date
Msg-id aadf90e9-4166-854e-ed56-76d92a77a705@gmail.com
Whole thread Raw
Responses Re: curiosity in default column header  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
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"?

pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Debugging postgres on Windows - could not open directory "/lib"
Next
From: "David G. Johnston"
Date:
Subject: Re: curiosity in default column header