Received: from mail1.tpgi.com.au (mail.tpgi.com.au [203.12.160.57]) by postgresql.org (Postfix) with ESMTP id CA829474E4E for ; Mon, 15 Apr 2002 21:25:05 -0400 (EDT) Received: from jac (bri2-56k-131.tpgi.com.au [203.29.144.131]) by mail1.tpgi.com.au (8.11.6/8.11.6) with SMTP id g3G1P6k11049 for ; Tue, 16 Apr 2002 11:25:06 +1000 Message-ID: <003b01c1e4e5$89c2c010$1400a8c0@jac> From: "jack" To: Subject: please advise on column data type Date: Tue, 16 Apr 2002 11:25:04 +1000 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Archive-Number: 200204/198 X-Sequence-Number: 7462 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