7.2 -> 7.3 incompatibility

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Hackers" <pgsql-hackers(at)postgresql(dot)org>
Subject: 7.2 -> 7.3 incompatibility
Date: 2003-02-03 02:54:07
Message-ID: GNELIHDDFBOCMGBFGEFOAEFGCFAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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' You will have to retype this query using an explicit cast

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

I guess this isn't so important, as there are workarounds (which are
complicated...)

Chris

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message alex avriette 2003-02-03 05:05:20 Irix 6.2, Postgres 7.3.1, some brokenness
Previous Message Justin Clift 2003-02-03 02:53:15 Re: Last call for 7.3.2