Received: from odin.isw.intel.com (swfdns01.isw.intel.com [192.55.37.143]) by postgresql.org (8.11.3/8.11.4) with ESMTP id f94Mrtn96925 for ; Thu, 4 Oct 2001 18:53:56 -0400 (EDT) (envelope-from christopher.w.maher@intel.com) Received: from swsmsxvs01.intel.com (swsmsxvs01.isw.intel.com [172.28.130.22]) by odin.isw.intel.com (8.9.1a+p1/8.9.1/d: relay.m4, v 1.44 2001/10/01 19:10:43 root Exp $) with SMTP id WAA12754 for ; Thu, 4 Oct 2001 22:53:47 GMT Received: from swsmsx17.isw.intel.com ([172.28.130.21]) by swsmsxvs01.intel.com (NAVGW 2.5.1.6) with SMTP id M2001100423523628194 for ; Thu, 04 Oct 2001 23:52:36 +0100 Received: by swsmsx17.isw.intel.com with Internet Mail Service (5.5.2653.19) id ; Thu, 4 Oct 2001 23:55:02 +0100 Message-ID: From: "Maher, Christopher W" To: "'pgsql-sql@postgresql.org'" Subject: SQL CONSTRAINTS - Constraining time values from two attributes on a table. Date: Thu, 4 Oct 2001 23:53:46 +0100 Importance: high X-Priority: 1 MIME-Version: 1.0 X-Mailer: Internet Mail Service (5.5.2653.19) Content-Type: text/plain; charset="ISO-8859-1" X-Archive-Number: 200110/83 X-Sequence-Number: 5039 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.