Tom Lane <tgl@sss.pgh.pa.us> wrote:
> "Tao Ma" <feng_eden@163.com> 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.
Tangential point: Maybe bpchar should be better documented for users,
since it does occassionally show up in user visible places. The only
current description that I could find (short of digging into the
source code) is here:
http://www.postgresql.org/docs/8.3/interactive/typeconv-query.html
Perhaps a mention should be added here, as it might be where people
would go looking for it?:
http://www.postgresql.org/docs/8.3/interactive/datatype-character.html
-Kevin