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