Thread: Primary Keys

Primary Keys

From
"Ray Hunter"
Date:
How are primary keys searched on...are they similar to how indexes work?


S RAY HUNTER
email: rhunter@venticon.com
www: http://www.venticon.com
aim: spinebl8d3





Re: Primary Keys

From
Philip Hallstrom
Date:
I can't say for sure, but I think they are identical to an index with a
unique constraint...

check the docs for more info.

On Wed, 21 Aug 2002, Ray Hunter wrote:

> How are primary keys searched on...are they similar to how indexes work?
>
>
> S RAY HUNTER
> email: rhunter@venticon.com
> www: http://www.venticon.com
> aim: spinebl8d3
>
>
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>


Re: Primary Keys

From
Oliver Elphick
Date:
On Thu, 2002-08-22 at 01:43, Ray Hunter wrote:
> How are primary keys searched on...are they similar to how indexes work?

Yes.  A unique index is automatically created when a primary key is
declared.

--
Oliver Elphick                                Oliver.Elphick@lfix.co.uk
Isle of Wight, UK
http://www.lfix.co.uk/oliver
GPG: 1024D/3E1D0C1C: CA12 09E0 E8D5 8870 5839  932A 614D 4C34 3E1D 0C1C
                 ========================================
     "For yourselves know perfectly that the day of the Lord
      so cometh as a thief in the night. For when they shall
      say, Peace and safety; then sudden destruction cometh
      upon them, as travail upon a woman with child; and
      they shall not escape."      I Thessalonians 5:2,3