w == wmo...@potentialtech.com writes:

 ...

 w> Your primary key can span multiple columns, i.e.
 w> PRIMARY KEY(jobclock_id, employee_id, machine_id)
 w> Could be more columns.

 w> Keep in mind that this ensures that the combination of all those
 w> columns is unique, which may or may not be what you want.


Sure.  I realize that a primary key can be made up of multiple
columns, but a unique constraint across the columns I need as
suggested by Matthew is what I was looking for.

Thanks.

-- 
Brandon

-- 
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to