"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

Reply via email to