Re: Date Question

Sharon,

> taupo-> AND OVERLAPS ('27-06-02', '11-07-02', date_from, date_to)
> taupo-> ORDER BY permit_id ;
> ERROR:  Function 'overlaps(unknown, unknown, date, date)' does not exist
>         Unable to identify a function that satisfies the given argument
types
>         You may need to add explicit typecasts

As the message says, you need to add explicit typecasts:

AND OVERLAPS ('27-06-02'::DATE, '11-07-02'::DATE, date_from, date_to)

--
-Josh Berkus