X-Original-To: pgsql-sql@postgresql.org Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 75C44474E5C for ; Tue, 11 Feb 2003 04:14:40 -0500 (EST) Received: from trill.maridan.net (unknown [217.6.52.210]) by postgresql.org (Postfix) with ESMTP id 3BD2B474E53 for ; Tue, 11 Feb 2003 04:14:39 -0500 (EST) Received: from polonium.de ([212.121.156.162]) by trill.maridan.net (8.9.3/8.9.3) with ESMTP id KAA21990 for ; Tue, 11 Feb 2003 10:14:39 +0100 Message-ID: <3E48BF5F.1060403@polonium.de> Date: Tue, 11 Feb 2003 10:16:15 +0100 From: Rafal Kedziorski Organization: POLONIUM User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.2.1) Gecko/20021130 X-Accept-Language: en-us, en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: which type for primary key? Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200302/209 X-Sequence-Number: 11607 Hi, I'm working on J2EE project with PostgreSQL (7.3.2). I know, that a number type is better for primary key as string. I want create primary keys as NUMBER(20). Is this a good idea? what will be a performance for this length? Best Regards, Rafal