Re: 7.2 -> 7.3 incompatibility

Christopher Kings-Lynne writes:

> I found an example of a casting problem in our source code now that we're
> running 7.3:
>
> SELECT CURRENT_DATE - EXTRACT(DOW FROM CURRENT_DATE);

A mathematically sound way to write this would be:

select current_date - extract(dow from current_data) * interval '1 day';

> I'm not sure really why DOW needs to be double precision, but hey...

Extract returns double precision. It can't morph itself based on the
argument type at run time.

--
Peter Eisentraut peter_e(at)gmx(dot)net