Re: Raw size - Mailing list pgsql-hackers

From Ioannis Theoharis
Subject Re: Raw size
Date
Msg-id Pine.GSO.4.58.0503111507300.18429@ourania.ics.forth.gr
Whole thread Raw
In response to Re: Raw size  ("Bort, Paul" <pbort@tmwsystems.com>)
List pgsql-hackers

>
> varchar means 'character varying'. What varies is the length. So a
> varchar(1000) with 'foo' in it only takes a few bytes ('foo' plus length
> info) instead of 1000 bytes.

Yes i know it, but i have vorgotten to inform you that all the values of
this attribute have really 1000 characthers length.

>
> If you really want a fixed-length field, nchar or char should do what you
> want.


pgsql-hackers by date:

Previous
From: Richard Huxton
Date:
Subject: Re: fool-toleranced optimizer
Next
From: Ioannis Theoharis
Date:
Subject: Re: Raw size