Re: string primary key

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(dot)kuria(at)unon(dot)org
+----------------------------------------------------+

>From: Bruno Wolff III <bruno(at)wolff(dot)to>
>To: Mark Gibson <mark(at)gibsonsoftware(dot)com>
>CC: pgsql-general(at)postgresql(dot)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(at)gibsonsoftware(dot)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(at)postgresql(dot)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/