Re: Replacing all CHAR colums with VARCHAR

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Andrus <kobruleht2(at)hot(dot)ee>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Replacing all CHAR colums with VARCHAR
Date: 2007-01-02 17:06:01
Message-ID: 20070102170601.GA20066@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Jan 02, 2007 at 02:37:59 +0200,
Andrus <kobruleht2(at)hot(dot)ee> wrote:
>
> Also Tom Lane strongly recommends using VARCHAR always and never use CHAR
> columns.

If you just want to use Postgres, you might want to use 'text' instead of
'varchar', since you don't need to specify arbitrarylimits for that type.
This isn't portable though.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2007-01-02 17:12:56 Re: OS X Tiger, and PostgreSQL 8.2 don't mix?
Previous Message Vlad 2007-01-02 16:53:44 PostgreSQL 8.2.1 expected release date?