Re: two-column primary key (not the typical question)
От
Chris Travers
Тема
Re: two-column primary key (not the typical question)
Дата
Msg-id
CAKt_ZfvB8jx+MgmqZWSHM8k17DjZWKrp+UHOEOGC+FDxUieM2g@mail.gmail.com
Ответ на
two-column primary key (not the typical question) (Chip Nowacek)
Список
Дерево обсуждения
two-column primary key (not the typical question) Chip Nowacek <chip@twostewards.com>
Re: two-column primary key (not the typical question) Gurjeet Singh <singh.gurjeet@gmail.com>
Re: two-column primary key (not the typical question) Chris Travers <chris.travers@gmail.com>
On Fri, Jul 6, 2012 at 7:00 PM, Chip Nowacek <chip@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 PKColBfoo barbar 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
В списке pgsql-general по дате отправления
