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