SQL CONSTRAINTS - Constraining time values from two attributes on a table.

From: "Maher, Christopher W" <christopher(dot)w(dot)maher(at)intel(dot)com>
To: "'pgsql-sql(at)postgresql(dot)org'" <pgsql-sql(at)postgresql(dot)org>
Subject: SQL CONSTRAINTS - Constraining time values from two attributes on a table.
Date: 2001-10-04 22:53:46
Message-ID: C406DCEF4576D511843B0002A5071ED54C9B5A@irsmsx104.ir.intel.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,
I was looking for a solution on how to write a constraint into a ' create
table ' expression that would ensure that one ' TIME ' attribute value
called arrival_time (declared as TIME) is allways constrained to have a
value that ensures it is allways after another attribute value called
departure_time (declared as TIME).
Any know how this constraint would be written??

Any help on this would be much appreciated,
Thanks,
Chris.

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Keith Gray 2001-10-04 23:47:24 Alias Join Table
Previous Message Ross J. Reedstrom 2001-10-04 22:33:56 Re: Need Help!!