Re: Primary key efficiency - Mailing list pgsql-novice

From V i s h a l Kashyap @ [Sai Hertz And Control Systems]
Subject Re: Primary key efficiency
Date
Msg-id 4013A702.3080608@sancharnet.in
Whole thread Raw
In response to Primary key efficiency  (Russell Shaw <rjshaw@iprimus.com.au>)
List pgsql-novice
Dear Russell Shaw ,

> Hi,

Hello

>
> Is a long field ok for a primary key, or should i use
> a unique integer?:

Unique Integer  is the most preferable thing as this retrive your data
at faster.
All said , if your select queries would use this primary key  for
identifying  tuples then better use integer


--
Regards,
Vishal Kashyap

~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
I Know you believe my words so logon to Jabber.org
and add vishalkashyap@jabber.org to your roster.
~*~*~*~*~*~*~*~*
I am usually called as Vishal Kashyap
but my Girlfriend calls me as Vishal CASH UP.
This is because others identify me because of my generosity
but my Girlfriend identify me because of my CASH.
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*


pgsql-novice by date:

Previous
From: Russell Shaw
Date:
Subject: Primary key efficiency
Next
From: Bill Moseley
Date:
Subject: Re: Hierarchal data