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?

Right now: yes, but I would like to see the char() type changed to a fixed length type (which it really is)
then it would have the length in attlen. Right now the length for char and varchar is in atttypmod.

Andreas


Wed, 11 Mar 1998 16:47:56 +-100
Zeugswetter Andreas <andreas.zeugswetter@telecom.at>
AW: [HACKERS] attlen weirdness?
> 
> 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?
> 
> Right now: yes, but I would like to see the char() type changed to a fixed length type (which it really is)
> then it would have the length in attlen. Right now the length for char and varchar is in atttypmod.
> 

Again, we can do this, but we then have to have atttypmod available in
all places where we check for length.  I will add it to the TODO list.

-- 
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)

Wed, 11 Mar 1998 14:08:04 -0500 (EST)
Bruce Momjian <maillist@candle.pha.pa.us>
Re: AW: [HACKERS] attlen weirdness?