Re: Question: unique on multiple columns - Mailing list pgsql-general

On Wed, Feb 05, 2003 at 08:09:13 -0600,
  will trillich <will@serensoft.com> 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)
     );