Re: character varying length

From: "Shoaib Mir" <shoaibmir(at)gmail(dot)com>
To: "developer(at)wexwarez(dot)com" <developer(at)wexwarez(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: character varying length
Date: 2006-12-09 08:08:10
Message-ID: bf54be870612090008y3571af47qb33726dff6ffe4d3@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I will recommend using the 'text' data type in that case for better
performance if you do not want to define the length...

Thank you,
-------------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)

On 12/9/06, developer(at)wexwarez(dot)com <developer(at)wexwarez(dot)com> wrote:
>
> Are there any negatives to not specifying the length variable of a
> character varying data type?
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Shoaib Mir 2006-12-09 08:19:33 Re: TOAD-like query builder for PostgreSQL?
Previous Message Tom Lane 2006-12-09 03:38:18 Re: localhost resolving