"Tao Ma" <[email protected]> writes:
> Is it really important to show the
> 'bpchar' if there is no any explicit casting for the column default value.
Yeah. We cannot say "char" because per SQL spec, that means "char(1)",
but there mustn't be a restriction to a single character here.
regression=# select 'abc'::char;
bpchar
--------
a
(1 row)
regression=# select 'abc'::bpchar;
bpchar
--------
abc
(1 row)
regards, tom lane
--
Sent via pgsql-hackers mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers