Re: [SQL] Size or efficiency differences "varchar(128) vs. varchar(32)"

2008-07-21 Thread Emi Lu
Sorry, forgot to replay all. Emi Lu wrote: May I know does varchar(128) and varchar(32) will cause any size or efficiency differences? None at all. Basically, there is no efficiency differences at all, if I know a column is now varchar(32) but could be potentially increased to length(co

Re: [SQL] Size or efficiency differences "varchar(128) vs. varchar(32)"

2008-07-21 Thread Scott Marlowe
On Mon, Jul 21, 2008 at 8:06 AM, Emi Lu <[EMAIL PROTECTED]> 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

Re: [SQL] Size or efficiency differences "varchar(128) vs. varchar(32)"

2008-07-21 Thread Alvaro Herrera
Emi Lu wrote: > May I know does varchar(128) and varchar(32) will cause any size or > efficiency differences? None at all. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-sq

[SQL] Size or efficiency differences "varchar(128) vs. varchar(32)"

2008-07-21 Thread Emi Lu
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? Thanks a lot! -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/ma