Re: Decade indication

2019-12-31 Thread Glyn Astill
Funnily enough I was having a conversation with my wife on exactly this as I opened your email. If the Wikipedia article is to be trusted, the following seems fitting:   SELECT EXTRACT(ORDINAL DECADE FROM '2020-01-01'::date);     date_part     ---           201 And the default:

Re: Opossum vs. float4 NaN

2019-01-27 Thread Glyn Astill
>> On Saturday, 26 January 2019, 16:00:24 GMT, Tom Lane wrote: >> >> I'm thinking we should regretfully retire opossum, unless there's >> a software update available for it that fixes this bug. I'm happy to update opossum to see if the issue goes away; likewise I'm just as happy to retire it