Where does catalog store CHAR length ?

From: "phd9110" <phd9110(at)cs(dot)nchu(dot)edu(dot)tw>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: Where does catalog store CHAR length ?
Date: 2003-12-01 10:31:56
Message-ID: 001f01c3b7f6$58acbfe0$6c0d788c@husky
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

hi
the table pg_attribute have the attribute "attlen" , and this attribute will
store the attribute length. For example , when integer , this value will be 4.
But if attribute type is Char(xx), this value will be -1. This is because it
reference the bychar in pg_type table.

So, where is the Char() length information store ??
and what time will system check this string length constraint ?

thanks for your help!
Kao , Nchu Taiwan

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Peter Eisentraut 2003-12-01 12:04:49 Foreign key data type mismatches
Previous Message Oliver Elphick 2003-12-01 07:29:57 Re: [HACKERS] initdb should create a warning message [was Re: