On Fri, Jul 6, 2012 at 7:00 PM, Chip Nowacek <chip(at)twostewards(dot)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