> In the schema for clin.table.lab-request > > where it declares > > fk_test_org integer UNIQUE#1 NOT NULL > request_id text UNIQUE#1 NOT NULL > > does the above define the uniqueness to be > > (fk_test_org + request_id) UNIQUE Yes.
> in other words there can be repeats within fk_test_org and repeats > within request_id but no repeat in the combined? Or in yet other words: The value for request_id may need to be repeatable across labs at the same time. > And Postgres is happy though the fields are of two different data types? Sure ! :-) Karsten -- GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS. Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail _______________________________________________ Gnumed-devel mailing list [email protected] http://lists.gnu.org/mailman/listinfo/gnumed-devel
