Re: pgsql: Implement jsonpath .datetime() method

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Alexander Korotkov <a(dot)korotkov(at)postgrespro(dot)ru>
Cc: Nikita Glukhov <n(dot)gluhov(at)postgrespro(dot)ru>, pgsql-committers <pgsql-committers(at)lists(dot)postgresql(dot)org>, Alexander Korotkov <akorotkov(at)postgresql(dot)org>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: pgsql: Implement jsonpath .datetime() method
Date: 2019-10-03 13:48:32
Message-ID: CA+TgmoaTdXT8wwmmnM3sBBG2FZQbb5DpXQBoJ+HSvsy6abQQeA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers pgsql-hackers

On Tue, Oct 1, 2019 at 1:41 PM Alexander Korotkov
<a(dot)korotkov(at)postgrespro(dot)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

In response to

Responses

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2019-10-03 17:56:49 pgsql: Allow repalloc() to give back space when a large chunk is downsi
Previous Message Andrew Gierth 2019-10-03 10:52:52 pgsql: Selectively include window frames in expression walks/mutates.

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2019-10-03 13:52:34 Re: Include RELKIND_TOASTVALUE in get_relkind_objtype
Previous Message Robert Haas 2019-10-03 13:39:56 Re: WIP/PoC for parallel backup