Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

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

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group