[GENERAL] Primary Key and Indices

Sun, 24 Apr 2005 09:54:41 -0700 

  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

---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings

Reply via email to