Re: Simple 'type' question

Thanks Tom.

Tim Barnard
S.E. Mgr
Hartford Communications Corporation

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


> "Tim Barnard" <tbarnard@povn.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
>