unique constraint on 2 columns
- From: Jonathan Vanasco <postgres(at)2xlp(dot)com>
- To: pgsql general <pgsql-general(at)postgresql(dot)org>
- Subject: unique constraint on 2 columns
- Date: Fri, 20 Apr 2007 16:52:37 -0400
- Message-id: <16BE9D41-D328-4F9F-A7D2-623388239D1E(at)2xlp(dot)com>
I need a certain unique constraint in pg that i can't figure out.
Given:
create table test_a (
id serial ,
name_1 varchar(32) ,
name_2 varchar(32)
);
I need name_1 and name_2 to both be unique so that:
name_1 never appears in name_1 or name_2
name_2 never appears in name_2 or name_1
a standard 2 column unique index / constraint will not accomplish this.
Home |
Main Index |
Thread Index