Using interger as opposed to a character as a primary key has an advantage
when it comes to querying data in the table, it is faster searching with an
interger as compared to characters date types
+-----------------------------------------------------+
| Martin W. Kuria (Mr.) [EMAIL PROTECTED]
+----------------------------------------------------+
From: Bruno Wolff III <[EMAIL PROTECTED]>
To: Mark Gibson <[EMAIL PROTECTED]>
CC: pgsql-general@postgresql.org
Subject: Re: [GENERAL] string primary key
Date: Fri, 12 May 2006 01:54:17 -0500
On Thu, May 11, 2006 at 09:52:41 -0600,
Mark Gibson <[EMAIL PROTECTED]> wrote:
> Is there a disadvantage to having the primary key for a table be a text
> type vs. an integer type? Performance? Any difference between having a
> varchar or char as a primary key?
You probably want to use 'text' unless there is a busniess rule limiting
the size of the field.
---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
_________________________________________________________________
Don't just search. Find. Check out the new MSN Search!
http://search.msn.click-url.com/go/onm00200636ave/direct/01/
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
