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