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 |