Re: pgsql: Implement jsonpath .datetime() method - Mailing list pgsql-committers

From Robert Haas
Subject Re: pgsql: Implement jsonpath .datetime() method
Date
Msg-id CA+TgmoaTdXT8wwmmnM3sBBG2FZQbb5DpXQBoJ+HSvsy6abQQeA@mail.gmail.com
Whole thread Raw
In response to Re: pgsql: Implement jsonpath .datetime() method  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
Responses Re: pgsql: Implement jsonpath .datetime() method  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
Re: pgsql: Implement jsonpath .datetime() method  (Alexander Korotkov <a.korotkov@postgrespro.ru>)
List pgsql-committers
On Tue, Oct 1, 2019 at 1:41 PM Alexander Korotkov
<a.korotkov@postgrespro.ru> wrote:
> So, basically standard requires us to suppress any error happening in
> filter expression.

Sounds like the standard is dumb, then. :-)

> But as I wrote before suppression of errors in
> datetime comparison may lead to surprising results.  That happens in
> rare corner cases, but still.  This makes uneasy choice between
> consistent behavior and standard behavior.

Yeah.

-- 
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company



pgsql-committers by date:

Previous
From: Andrew Gierth
Date:
Subject: pgsql: Selectively include window frames in expression walks/mutates.
Next
From: Tom Lane
Date:
Subject: pgsql: Allow repalloc() to give back space when a large chunk is downsi