pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: elisabeth maniez <emaniez@caramail.com>
To: pgsql-sql@postgresql.org
Subject: Re: create table with multiple unique fields
Date: Sun, 13 Jan 2002 09:23:16 +0100
Message-ID: <a1rgih$2fjj$1@news.tht.net> (raw)
References: <a1agea$qap$1@news.tht.net>

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
>
>





view thread (2+ messages)

Message-ID: <a1rgih$2fjj$1@news.tht.net>
Permalink:  ../a1rgih$2fjj$1@news.tht.net/
Also on:    postgresql.org/message-id/a1rgih$2fjj$1@news.tht.net

 · 

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: emaniez@caramail.com
  Subject: Re: create table with multiple unique fields
  In-Reply-To: <a1rgih$2fjj$1@news.tht.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox