Re: [GENERAL] two-column primary key (not the typical question)

2012-07-06 Thread Gurjeet Singh
On Fri, Jul 6, 2012 at 10:00 PM, Chip Nowacek wrote: > I need a suggestion. I need a two-column primary key that does not depend > on the order of the entries. That is, for the purposes of the key: > > PKColA PKColB > foobar > barfoo > > is not valid. > I don't think

Re: [GENERAL] two-column primary key (not the typical question)

2012-07-06 Thread Chris Travers
On Fri, Jul 6, 2012 at 7:00 PM, Chip Nowacek wrote: > I need a suggestion. I need a two-column primary key that does not depend > on the order of the entries. That is, for the purposes of the key: > > PKColA PKColB > foobar > barfoo > What about a unique functional in

[GENERAL] two-column primary key (not the typical question)

2012-07-06 Thread Chip Nowacek
I need a suggestion. I need a two-column primary key that does not depend on the order of the entries. That is, for the purposes of the key: PKColA PKColB foobar barfoo is not valid. Any help would be appreciated.