You cannot cast +/- infinity timestamp to date
Thank you.
All my dates are in nearest centuries. So I fixed this by creating function
CREATE OR REPLACE FUNCTION public.doverlaps(date,date, date, date, out bool)
immutable AS
$_$
SELECT coalesce($1, date '0001-01-01') <=coalesce($4, date '999
On May 21, 4:49 am, "Andrus" <[EMAIL PROTECTED]> wrote:
> I'm using this for emplyment, vacation, illness etc. period calculation.
> OVERLAPS produces invalid result in this case for DATE as discussed in other
> thread.
>
> select doverlaps(date '2007-01-01',date '2007-01-02',date '2007-01-02',date
On May 20, 1:39 pm, "Andrus" <[EMAIL PROTECTED]> wrote:
> I need to check when two date intervals overlap.
> Some date interval values may be null.
>
> I created the following function but
>
> select doverlaps( null, null, null, null);
>
> returns null.
>
> How to fix this so that null values are a
