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 [EMAIL PROTECTED] ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
