Re: character datatype explaination sought

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
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:19:59
Message-ID: 4dd5afc1c5524a59309599ad4894ac565b9c21b0.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2020-10-15 14:21:06 Re: character datatype explaination sought
Previous Message Tom Lane 2020-10-15 14:19:53 Re: character datatype explaination sought