Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iG1TM-0003eq-SE for pgsql-committers@arkaria.postgresql.org; Thu, 03 Oct 2019 13:48:49 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1iG1TL-0004NX-J9 for pgsql-committers@arkaria.postgresql.org; Thu, 03 Oct 2019 13:48:47 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1iG1TL-0004NF-6k for pgsql-committers@lists.postgresql.org; Thu, 03 Oct 2019 13:48:47 +0000 Received: from mail-lf1-x144.google.com ([2a00:1450:4864:20::144]) by makus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1iG1TI-0006WR-Tn for pgsql-committers@lists.postgresql.org; Thu, 03 Oct 2019 13:48:46 +0000 Received: by mail-lf1-x144.google.com with SMTP id r22so1917444lfm.1 for ; Thu, 03 Oct 2019 06:48:44 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=q9InxAiIV9rWXqyljnKe+RTx/9pf8Tosbz5IJggH6/Y=; b=YMwGU0MZWZrjLT8V7cEObm66m+ZpqUx32niaIzwZaZP2Tzn+Je6EmhUVrcuuKWsh4A HCZMtIEbjuQegl3lUgtVTMbWY7cpEftTvtuqdBinVWVVxM6k122kuTbm3LV6dimzqt+v iekkBDbwGtOMn8hxajIr+Oil5voTBA/6MbD//7ddZNaJT1CZlUc7FK9EPf28OlK4Cfdy SS63DRmYZizC4YpuKxFwVAWRbKkUbaenhOFi2iki/Cf/reBVCibfAyK+eyaJ6OxLfh1W LFwgC4jyvVbh+Ernq7slFZa8SS7BehKiexehBSRT3bkyEEHO3PBcRpSeokBMcYPyNmZV Nvng== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=q9InxAiIV9rWXqyljnKe+RTx/9pf8Tosbz5IJggH6/Y=; b=qh7DD04Mnfge2aWor1xN25a7YUgKnXh2jwxPuwLqGOlteilyc/gkIFOLe9jM/gSd5A 3sos1jPTlpapIc2fIuCqLZ4otDz4cQxK9K7Uk8ycuoE2IRZxzrbvlnpYoL43Aq+4cS+9 ioWh7Bf4n/GYWmdczQ5JKcaGO0rabI8G5N9mzG4+HQeBiqqr3csCM5gJ1GsFKlPKWlJt d+CF8JCcx8G/xh10m6f3soBraPMbDqDZsGuHed2jpQeODU86Oa6U7vUG+MsR8+Okdrg3 LWh03c8XlEhWlrg2ilz8vZMHnLI1EYNXhDEswdTSPCAU7b12arcHWKX22WZDTpQKLJF4 /UZA== X-Gm-Message-State: APjAAAUXjdac7i9sy8SshYV2ESXVw7Z7xb3NJ8F8GDTVquW6l53N2W/r dNswjekgQDu83xthAoqvfUVAbKLmtG4meiWI5bg= X-Google-Smtp-Source: APXvYqy4n4iKJmghZ0mjhXEIpyyHRhY1bLFWil8+Af89EocW8Qy+MwD3rTLC38PVuxbgCgD9aDWE7p3nV7tt2dY/yFw= X-Received: by 2002:ac2:4853:: with SMTP id 19mr5745774lfy.69.1570110523314; Thu, 03 Oct 2019 06:48:43 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: Robert Haas Date: Thu, 3 Oct 2019 09:48:32 -0400 Message-ID: Subject: Re: pgsql: Implement jsonpath .datetime() method To: Alexander Korotkov Cc: Nikita Glukhov , pgsql-committers , Alexander Korotkov , Tom Lane , pgsql-hackers Content-Type: text/plain; charset="UTF-8" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On Tue, Oct 1, 2019 at 1:41 PM Alexander Korotkov 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