Thread: Primary Keys
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
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) >
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