Re: character datatype explaination sought

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: byrnejb(at)harte-lyne(dot)ca, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: character datatype explaination sought
Date: 2020-10-15 14:21:06
Message-ID: 576b940c-0cbc-6af2-b5d2-68c60cf7d749@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Raj Iyer 2020-10-15 17:22:51 Question on postgres certified OS platforms
Previous Message Laurenz Albe 2020-10-15 14:19:59 Re: character datatype explaination sought