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

Поиск
Список
Период
Сортировка
От Maher, Christopher W
Тема SQL CONSTRAINTS - Constraining time values from two attributes on a table.
Дата
Msg-id C406DCEF4576D511843B0002A5071ED54C9B5A@irsmsx104.ir.intel.com
обсуждение исходный текст
Ответы 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>)
Список 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.


В списке pgsql-sql по дате отправления:

Предыдущее
От: "Bob Swerdlow"
Дата:
Сообщение: Re: ORDER BY case insensitive?
Следующее
От: Vladimir Vukicevic
Дата:
Сообщение: getting OID from PL/PgSQL AFTER trigger