Simple 'type' question

From: "Tim Barnard" <tbarnard(at)povn(dot)com>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Simple 'type' question
Date: 2002-01-24 23:11:36
Message-ID: 018a01c1a52c$790ca360$a519af3f@hartcomm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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? Or will the implicit index that's created on the primary
key work equally well with either type? Any suggestions would be much
appreciated.

Tim Barnard
S.E. Mgr
Hartford Communications Corporation

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-01-24 23:49:30 Re: Is there a drawback when changing NAMEDATALEN to 64?
Previous Message Steve Boyle (Roselink) 2002-01-24 22:08:45 Re: graphical windows client for postgresql