. Is this possible?
On Tue, May 1, 2012 at 2:38 PM, Misa Simic misa.si...@gmail.com wrote:
Hi
I think for overlaping exclusion constraint you need period extension
or range datatype in 9.2
Kind Regards,
Misa
Sent from my Windows Phone
From: bradford
Sent: 01/05/2012 19:16
To: pgsql-general
I would like to prevent overlapping dates ranges for col1 + col2 from
being inserted into my test table.
Existing Data:
1, FOO, 2012-04-04, 2012-04-06
Insert Attempts:
1, FOO, 2012-04-05, 2012-04-08 -- BAD, overlaps w/ above!
1, BAR, 2012-04-04, 2012-04-06 -- OK, no conflict!
2, FOO, 2012-04-04,
at time zone 'UTC') ),
point( extract(epoch FROM to_ts at time zone 'UTC') ,
extract(epoch FROM to_ts at time zone 'UTC') )
) WITH
)
);
On Tue, May 1, 2012 at 1:26 PM, Richard Broersma
richard.broer...@gmail.com wrote:
On Tue, May 1, 2012 at 10:15 AM, bradford fingerm...@gmail.com wrote