Re: Raw size

From: Ioannis Theoharis <theohari(at)ics(dot)forth(dot)gr>
To: "Bort, Paul" <pbort(at)tmwsystems(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Raw size
Date: 2005-03-11 13:08:34
Message-ID: Pine.GSO.4.58.0503111507300.18429@ourania.ics.forth.gr
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Ioannis Theoharis 2005-03-11 13:23:27 Re: Raw size
Previous Message Richard Huxton 2005-03-11 10:56:47 Re: fool-toleranced optimizer