Re: character datatype explaination sought - Mailing list pgsql-general

On 10/15/20 7:07 AM, James B. Byrne wrote:
> I am testing Idempiere and have run across this in an example:
> 
> character(1) DEFAULT 'Y'::bpchar NOT NULL,
> 
> How does this differ from
> 
> character(1) DEFAULT 'Y' NOT NULL,

It doesn't. From here:

https://www.postgresql.org/docs/current/typeconv-query.html

"...  bpchar (“blank-padded char”, the internal name of the character 
data type) ..."

> 
> 
> 


-- 
Adrian Klaver
adrian.klaver@aklaver.com