Roland Roberts <[EMAIL PROTECTED]> writes:
>> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
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,
To
> "Tom" == Tom Lane <[EMAIL PROTECTED]> writes:
Tom> "Klein, Robert" <[EMAIL PROTECTED]> 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
"Klein, Robert" <[EMAIL PROTECTED]> 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?
Must have been quite a few versions back; attlen has been -1 for
variable-length datatypes for as long as
I just answered my own question. atttypmod now holds this value.
thanks,
Rob
-Original Message-
From: Klein, Robert [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, May 03, 2000 4:27 PM
To: [EMAIL PROTECTED]
Cc: [EMAIL PROTECTED]
Subject: [BUGS] Need some help: attlen is pg_attributes gives
I have a table defined as:
create table contacts (
c_name char (20),
c_title char (30),
c_phone char (13),
c_extchar (5),
c_email char (60),
c_sort char (5)
);
when I query the catalog to get the field length for auto generating HTML
forms I g
