Re: Primary Key and Indices

On Sun, 2005-04-24 at 09:49 -0700, Rich Shepard wrote:
>    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?

yes.
for example, only the first one can be used for ORDER BY org_id

gnari