which type for primary key?

From: Rafal Kedziorski <rafcio(at)polonium(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: which type for primary key?
Date: 2003-02-11 09:16:15
Message-ID: 3E48BF5F.1060403@polonium.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Alexander Stanier 2003-02-11 10:02:47 Re: On delete cascade not working
Previous Message Arunachalam Jaisankar 2003-02-11 03:55:28 null foreign key column