Postgres Pro
Downloads
Home   >   mailing lists

SQL CONSTRAINTS - Constraining time values from two attributes on a table. - Mailing list pgsql-sql

From Maher, Christopher W
Subject SQL CONSTRAINTS - Constraining time values from two attributes on a table.
Date
Msg-id C406DCEF4576D511843B0002A5071ED54C9B5A@irsmsx104.ir.intel.com
Whole thread Raw
Responses Re: SQL CONSTRAINTS - Constraining time values from two attributes on a table.  ("Josh Berkus" <josh@agliodbs.com>)
Re: SQL CONSTRAINTS - Constraining time values from two  (Peter Eisentraut <peter_e@gmx.net>)
List pgsql-sql
Tree view 
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.

pgsql-sql by date:

Previous
From: "Bob Swerdlow"
Date:
Subject: Re: ORDER BY case insensitive?
Next
From: Vladimir Vukicevic
Date:
Subject: getting OID from PL/PgSQL AFTER trigger