Postgres Pro
Downloads
Home   >   mailing lists

which type for primary key? - Mailing list pgsql-sql

From Rafal Kedziorski
Subject which type for primary key?
Date
Msg-id 3E48BF5F.1060403@polonium.de
Whole thread Raw
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Josh Berkus
Date:
Subject: Re: conversi ms-sql7 vs postgresql 7.3
Next
From: "Alexander Stanier"
Date:
Subject: Re: On delete cascade not working