Re: Size or efficiency differences "varchar(128) vs. varchar(32)" - Mailing list pgsql-sql

From Scott Marlowe
Subject Re: Size or efficiency differences "varchar(128) vs. varchar(32)"
Date
Msg-id dcc563d10807210917w5382e41an8355b0810a958213@mail.gmail.com
Whole thread Raw
In response to Size or efficiency differences "varchar(128) vs. varchar(32)"  (Emi Lu <emilu@encs.concordia.ca>)
List pgsql-sql
On Mon, Jul 21, 2008 at 8:06 AM, Emi Lu <emilu@encs.concordia.ca> wrote:
> Good morning,
>
> I'd like to create a varchar length column.
>
> May I know does varchar(128) and varchar(32) will cause any size or
> efficiency differences?

If you store the same thing in each, no.  If you store 128 char  text
in the varchar(128) it will of course be bigger than a 32 char text in
the varchar(32) field.


pgsql-sql by date:

Previous
From: Alvaro Herrera
Date:
Subject: Re: Size or efficiency differences "varchar(128) vs. varchar(32)"
Next
From: Emi Lu
Date:
Subject: Re: Size or efficiency differences "varchar(128) vs. varchar(32)"