Re: Simple 'type' question

Thanks Tom.

Tim Barnard
S.E. Mgr
Hartford Communications Corporation

----- Original Message -----
From: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Tim Barnard" <tbarnard(at)povn(dot)com>
Cc: <pgsql-general(at)postgresql(dot)org>
Sent: Thursday, January 24, 2002 3:51 PM
Subject: Re: [GENERAL] Simple 'type' question

> "Tim Barnard" <tbarnard(at)povn(dot)com> writes:
> > When creating a table with a primary key that can contain any varying
> > sequence of alphanumeric characters, is it best to use the 'text' type
or
> > the 'varchar' type?
>
> If you want a specific upper limit on the string length, use varchar.
> If that's not needed, use text. The only difference in performance
> AFAIK is the extra function call per insert/update for the routine that
> enforces the varchar limit.
>
> regards, tom lane
>