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@gmx.net