Re: Where does catalog store CHAR length ? - Mailing list pgsql-hackers

From Alvaro Herrera
Subject Re: Where does catalog store CHAR length ?
Date
Msg-id 20031201133217.GB14543@dcc.uchile.cl
Whole thread Raw
In response to Where does catalog store CHAR length ?  ("phd9110" <phd9110@cs.nchu.edu.tw>)
List pgsql-hackers
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)


pgsql-hackers by date:

Previous
From: Andreas Pflug
Date:
Subject: Re: Foreign key data type mismatches
Next
From: Alvaro Herrera
Date:
Subject: Re: default operator class: btree or hash