Re: Question: unique on multiple columns

On Wed, Feb 05, 2003 at 08:09:13 -0600,
  will trillich  wrote:
> On Wed, Feb 05, 2003 at 06:46:35AM -0500, roverr wrote:
> > I'm running postgresql 7.2.1.
> > Is there a way to specify a constraint such that the combination
> > of two columns in a table is unique?
> 
> 	create table something (
> 		a int4,
> 		b varchar(20),
> 		c timestamp
> 	);
> 	create unique index on something ( a, c );
> 	create unique index on something ( b, c, a );

While that will work, I think the following format is a little better.
 	create table something (
 		a int4,
 		b varchar(20),
 		c timestamp,
                unique(a,c),
                unique(b,c,a)
 	);