Re: select based on multi-column primary keys

On Fri, Jan 19, 2007 at 07:45:40PM -0800, codeWarrior wrote:
> AFAIK: You cannot have multiple primary keys. How would you know which one
> is the actual key ?

You can have a multi-column primary key, though. That's a perfectly
legitimate approach.

> FYI: What you are really talking about are table contraints... When you have

No, it's a multi-column primary key.

> My advice would be to alter your table structure so that you have a "real"
> PK not table constraints -- that would make it searchable....

This is already searchable. What you are talking about is not a real
primary key, but an artificial one. The OP already has a real
primary key. SQL purists think artificial primary keys mean that you
haven't done enough normalisation. I'm going to remain silent on
that topic, though, so that we don't get a Thread That Does Not End
:)

A

--
Andrew Sullivan | ajs(at)crankycanuck(dot)ca
If they don't do anything, we don't need their acronym.
--Josh Hamilton, on the US FEMA