Column References

From: "Epps, Aaron M(dot)" <Epps(dot)Aaron(at)mayo(dot)edu>
To: "'pgsql-admin(at)postgresql(dot)org'" <pgsql-admin(at)postgresql(dot)org>
Subject: Column References
Date: 2003-10-31 19:44:40
Message-ID: AFB1612D9C37D21182E0006008A1F6F813D30E8C@excsrv14.mayo.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I've got a question about references, is it possible to specify criteria for the Reference. For example, Table 1 has Field1 That References Field1 in Table2, However I only want Field 1 in Table 1 to reference the Records in Table2 that have the Valid Field set to TRUE. In other words, I don't want the user to be able to enter invalid records from table 2 into field 1 in table 1. Is there a different way of accomplishing the same thing?


Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Lane 2003-10-31 19:45:57 Re: dumping tables from badly damaged db
Previous Message PostgreSQL 2003-10-31 19:33:09 SELECT COUNT(*)... returns 0 ROWS