constraint help

From: Dennis Gearon <gearond(at)fireserve(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: constraint help
Date: 2004-04-14 17:24:56
Message-ID: 407D73E8.3090807@fireserve.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I will have a table with, among other things, two time columns.
As per my last post, I will be using a variable time for the day-to-day
boundary, versus the traditional 12pm.
What I want to be able to do upon insert of a record with a pair of
times is to determine if the day to day boundary is between the times
that are in the record, and reject the record if that is true.
For example, if the system wide constant for the day-to-day boundary
were 4AM local time, and I submitted a record like so:
INSERT INTO my_table(start_time, end_time) VALUES( '12:00'::TIME,
'14:30'::TIME );

that should succeed. However:
INSERT INTO my_table(start_time, end_time) VALUES( '12:00'::TIME,
'5:00'::TIME );

should fail.
Any ideas wold be most appreciated.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Marc G. Fournier 2004-04-14 17:35:51 Re: Donating
Previous Message Anthony 2004-04-14 17:19:51 Re: PostgreSQL Invalid Page Header in Block XXXXX