Postgres Pro
Downloads
Home   >   mailing lists

Primary Key and Indices - Mailing list pgsql-general

From Rich Shepard
Subject Primary Key and Indices
Date
Msg-id Pine.LNX.4.61.0504240945590.4797@salmo.appl-ecosys.com
Whole thread Raw
Responses Re: Primary Key and Indices  (Ragnar Hafstað <gnari@simnet.is>)
List pgsql-general
Tree view 
   I'm converting mysql tables to postgres. One of the tables has this:

   PRIMARY KEY (org_id, contact_id),
   KEY contact (contact_id, org_id)

   Is there really a difference in the two indices if the sequence of fields
is reversed?

Thanks,

Rich

--
Dr. Richard B. Shepard, President
Applied Ecosystem Services, Inc. (TM)
<http://www.appl-ecosys.com>   Voice: 503-667-4517   Fax: 503-667-8863

pgsql-general by date:

Previous
From: Michael Fuhr
Date:
Subject: Re: timezone() with timeofday() converts the wrong direction?
Next
From: Karsten Hilbert
Date:
Subject: Re: timezone() with timeofday() converts the wrong direction?