>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:
Tom> "Klein, Robert" <rvklein@ober.com> writes:
>> [ attlen for a char(n) field is -1 ]
>> I know in previous versions the length as defined in the create
>> table statement was given. Any ideas?
Tom> Must have been quite a few versions back; attlen has been -1
Tom> for variable-length datatypes for as long as I've been paying
Tom> attention. (Of course char(n) isn't *really* variable length,
Tom> but it's treated that way so that the representation is the
Tom> same as for varchar(n) and text.)
When did this change? I haven't looked 6.5, but I thought 6.3 still
has bpchar as fixed length and char(n) was blank padded whereas
varchar was not.
roland
--
PGP Key ID: 66 BC 3B CD
Roland B. Roberts, PhD Unix Software Solutions
roberts@panix.com 76-15 113th Street, Apt 3B
rbroberts@acm.org Forest Hills, NY 11375