On Mon, 2003-02-10 at 19:13, Peter Eisentraut wrote:
> 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
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
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);
(Get's the start of the week);
This worked in 7.2, but fails in 7.3 with:
ERROR: Unable to identify an operator '-' for types 'date' and 'double
precision
