Re: Why overlaps is not working

From: "Andrus" <eetasoft(at)online(dot)ee>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Re: Why overlaps is not working
Date: 2006-11-13 12:24:52
Message-ID: 033601c7071e$c1684d40$2300b3a8@Andrus
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> What you meant to test is:
>
> select (date '20060101'::timestamp,
> coalesce(NULL, 'infinity'::timestamp))
> overlaps
> (date '20060102'::timestamp,
> coalesce(NULL, 'infinity'::timestamp))
>
> Which returns true.

Alban,

If first period end and second period start dates are the same, I need that in this case expression
returns true.
Is it possible to implement this using OVERLAPS operator ?

Andrus.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rodrigo Sakai 2006-11-13 12:37:51 Inserting data in composite types
Previous Message Alban Hertroys 2006-11-13 12:04:25 Re: Why overlaps is not working