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.) martin.kuria@unon.org
+----------------------------------------------------+
>From: Bruno Wolff III <bruno@wolff.to>
>To: Mark Gibson <mark@gibsonsoftware.com>
>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 <mark@gibsonsoftware.com> 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 majordomo@postgresql.org 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/