Horton

Re: [HACKERS] attlen weirdness?

Bruce Momjian <maillist@candle.pha.pa.us>

View thread
From: Bruce Momjian <maillist@candle.pha.pa.us>
To: julie@postgreSQL.org (Julia A.Case)
Cc: julie@hub.org, scrappy@hub.org, pgsql-hackers@postgreSQL.org
Date: 1998-03-11T15:20:35Z
Lists: pgsql-hackers 
> 
> Quoting Bruce Momjian (maillist@candle.pha.pa.us):
> > I assume you are asking of attlen for char() and varchar() have the max
> > length.  The answer is now NO.  They are varlena structures like text,
> > and so have a attlen of -1.  Atttypmod for that pg_attribute row now has
> > the defined length.
> > 
> 
> 	Even for a char(4) field?  ok, if attlen doesn't give the
> length of a field, how do I find it?

pg_attribute.atttypmod.

-- 
Bruce Momjian                          |  830 Blythe Avenue
maillist@candle.pha.pa.us              |  Drexel Hill, Pennsylvania 19026
  +  If your life is a hard drive,     |  (610) 353-9879(w)
  +  Christ can be your backup.        |  (610) 853-3000(h)