On 9/11/15 7:45 AM, Anastasia Lubennikova wrote:
This idea has obvious restriction. We can set unique only for first
index columns.
There is no clear way to maintain following index.
CREATE INDEX index ON table (c1, c2, c3) UNIQUE ON (c1, c3);

So I suggest following syntax:
table_name (column_name1, column_name2 ...);

I would use the first (simple) syntax and just throw an error if the user tries to skip a column on the UNIQUE clause.

Have you by chance looked to see what other databases have done for syntax? I'm guessing this isn't covered by ANSI but maybe there's already an industry consensus.
Jim Nasby, Data Architect, Blue Treble Consulting, Austin TX
Experts in Analytics, Data Architecture and PostgreSQL
Data in Trouble? Get it in Treble! http://BlueTreble.com

Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:

Reply via email to