String plus interval result in program errors upon comparison #3002
Last updated: 2012-03-16 14:56:56 +0100
Date: 2012-02-09 00:53:35 +0100
User-Agent: Mozilla/5.0 (X11; Linux i686) AppleWebKit/535.2 (KHTML, like Gecko) Chrome/15.0.874.83 Safari/535.2
select '1970-01-01 11:00' - interval '600' second;
select cast('1970-01-01 11:00' as timestamp) = '1970-01-01 11:00' - interval '600' second;
Date: 2012-02-13 14:47:14 +0100
It would be helpful if you didn't just copy-and-paste the query and the error, but also wrote what it was you expected and why you think something is wrong.
Date: 2012-02-13 15:02:40 +0100
In my opinion anything is wrong when a user is informed that a program contains errors, especially because it is not a message that a human can understand and is out of protocol.
Date: 2012-02-27 15:57:13 +0100
we now disallow converts from interval to timestamps
Date: 2012-03-16 14:56:56 +0100
Released in Dec2011-SP2
The text was updated successfully, but these errors were encountered: