Where does catalog store CHAR length ?
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
On Mon, Dec 01, 2003 at 06:31:56PM +0800, phd9110 wrote:
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 ??
atttypmod is the maximum length + 4.
--
Alvaro Herrera (<alvherre[a]dcc.uchile.cl>)
"El destino baraja y nosotros jugamos" (A. Schopenhauer)