please advise on column data type

From: "jack" <datactrl(at)tpg(dot)com(dot)au>
To: <pgsql-sql(at)postgresql(dot)org>
Subject: please advise on column data type
Date: 2002-04-16 01:25:04
Message-ID: 003b01c1e4e5$89c2c010$1400a8c0@jac
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

When I create a table can I always use the rule, use VARCHAR for all
variable length string data and use CHAR for only fixed length string data.
Or I have to consider if the column will be set as an index or primary key,
it would be better to use CHAR for better performance.

JACK

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Christopher Kings-Lynne 2002-04-16 01:53:51 Re: How slow is DISTINCT?
Previous Message Tom Lane 2002-04-15 20:47:27 Re: oid and oidvector