Обсуждение: Where does catalog store CHAR length ?

Поиск
Список
Период
Сортировка

Where does catalog store CHAR length ?

От
"phd9110"
Дата:
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

Re: Where does catalog store CHAR length ?

От
Alvaro Herrera
Дата:
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)