On Fri, Jul 6, 2012 at 7:00 PM, Chip Nowacek <c...@twostewards.com> 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 > foo bar > bar foo > What about a unique functional index which would return some sort of ordered representation of this along with NOT NULL constraints? I don't know if you can do it as a simple primary key, but you can probably get unique functional indexes to do the main work for you. Best Wishes, Chris Travers
