Thread

1. AW: [HACKERS] attlen weirdness?

   Andreas Zeugswetter <andreas.zeugswetter@telecom.at> — 1998-03-11T15:47:56Z

   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
   
   
   

2. Re: AW: [HACKERS] attlen weirdness?

   Bruce Momjian <maillist@candle.pha.pa.us> — 1998-03-11T19:08:04Z

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