Re: Need some help: attlen is pg_attributes gives a negative value.. .

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Need some help: attlen is pg_attributes gives a negative value.. .
Дата
Msg-id 200005050412.AAA09310@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: Need some help: attlen is pg_attributes gives a negative value.. .  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
> Roland Roberts <roberts@panix.com> writes:
> >>>>>> "Tom" == Tom Lane <tgl@sss.pgh.pa.us> writes:
> Tom> Must have been quite a few versions back; attlen has been -1
> Tom> for variable-length datatypes for as long as I've been paying
> Tom> attention. (Of course char(n) isn't *really* variable length,
> Tom> but it's treated that way so that the representation is the
> Tom> same as for varchar(n) and text.)
>
> > When did this change?  I haven't looked 6.5, but I thought 6.3 still
> > has bpchar as fixed length and char(n) was blank padded whereas
> > varchar was not.
>
> char(n) was and is blank-padded, varchar(n) was and is not.  Sorry
> if I was imprecise enough to convey a different impression.
>
> I'm fairly sure that attlen had its present semantics in 6.4.  6.3
> was before my time; any old-timers care to comment?

Since day 1, they were that way.  atttypmod was added in 6.3.

--
  Bruce Momjian                        |  http://www.op.net/~candle
  pgman@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: query slowness caused by table alias
Следующее
От: Roland Roberts
Дата:
Сообщение: Re: Need some help: attlen is pg_attributes gives a negative value.. .