AW: [HACKERS] attlen weirdness? - Mailing list pgsql-hackers

From Zeugswetter Andreas
Subject AW: [HACKERS] attlen weirdness?
Date
Msg-id 01BD4D0D.7385BCE0@pc9358.sd.spardat.at
Whole thread Raw
Responses Re: AW: [HACKERS] attlen weirdness?
List 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?

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


pgsql-hackers by date:

Previous
From: Zeugswetter Andreas
Date:
Subject: Re: [HACKERS] indexing words slow
Next
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] attlen weirdness?