Re: create table with multiple unique fields - Mailing list pgsql-sql

create table T1 ( c1  int4, c2  int4, c3  int4, c4  int4, c5  int5, primary
key  (c1,c2,c3) );

Elisabeth
"Karl Raven" <lcaasia@pd.jaring.my> a �crit dans le message news:
a1agea$qap$1@news.tht.net...
>
> I'd like to create a table with 3 create unique fields :
>
> fields
> warehouseno,loc, productid, qty, qtyalllocated
>
> i'd like warehouseno,loc, productid to be unique..
> meaning
> 2000, ABC, X           - ok
> 2000,ABC,Y            -ok
> 2000,ABC,X            - reject
> 2000,BCD,X            - ok
>
> anyone knows how to do so?
>
> thanks
>
>