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

On Thu, 2020-10-15 at 10:07 -0400, 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 is the same, only in the first version the type cast is explicit.

Yours,
Laurenz Albe
-- 
Cybertec | https://www.cybertec-postgresql.com