Ah, I was completely unaware of tuple_(). That's what I was looking for.
Thanks!
keskiviikko, 18. joulukuuta 2013 18.31.42 UTC+2 Michael Bayer kirjoitti:
On Dec 17, 2013, at 8:39 PM, Alex Grönholm
alex.g...@nextday.fijavascript:
wrote:
I would like to check if two date ranges overlap.
On Dec 17, 2013, at 8:39 PM, Alex Grönholm alex.gronh...@nextday.fi wrote:
I would like to check if two date ranges overlap. This is done using the
OVERLAPS operator.
For example:
SELECT (DATE '2001-02-16', DATE '2001-12-21') OVERLAPS
(DATE '2001-10-30', DATE '2002-10-30');
How
I would like to check if two date ranges overlap. This is done using the
OVERLAPS
operator http://www.postgresql.org/docs/9.2/static/functions-datetime.html
.
For example:
SELECT (DATE '2001-02-16', DATE '2001-12-21') OVERLAPS
(DATE '2001-10-30', DATE '2002-10-30');
How do I do this in