Re: Question: unique on multiple columns

On Wed, 2003-02-05 at 09:09, will trillich wrote:
> On Wed, Feb 05, 2003 at 06:46:35AM -0500, roverr wrote:
<snip>
> > I have a table as follows:
> > col 1: id, type serial, primary key
> > col 2: host_id, type integer, foreign key to hosts table
> > col 3: data_time, type timestamp
> > col 4 - 9 data that is unique to col 2 and 3
> >

<snip>
>
> you can
>
>     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 );
>
> i don't understand your cols 4-9, tho. is this what you're
> looking for?
>
Yes, thanks, thats what I was looking for.
Columns 4-9 are data that that corresponds to a unique
combination of b and c (and necessarily a).
Regards, Gary

> --
> There are 10 kinds of people:
> ones that get binary, and ones that don't.
>
> will@serensoft.com