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 1h0cYN-00077J-EG for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Mar 2019 01:38:03 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1h0cYL-00037R-70 for pgsql-hackers@arkaria.postgresql.org; Mon, 04 Mar 2019 01:38:01 +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 1h0cYK-00037K-SI for pgsql-hackers@lists.postgresql.org; Mon, 04 Mar 2019 01:38:01 +0000 Received: from mail-yw1-xc41.google.com ([2607:f8b0:4864:20::c41]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1h0cYD-0005Yt-Lw for pgsql-hackers@postgresql.org; Mon, 04 Mar 2019 01:37:59 +0000 Received: by mail-yw1-xc41.google.com with SMTP id 189so2894312ywi.3 for ; Sun, 03 Mar 2019 17:37:53 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=from:subject:to:cc:references:openpgp:autocrypt:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding :content-language; bh=vNCIE9RLLOS+CUtVyqQGQrh4o+wgdNWvFkxRuvBn/ck=; b=w4vS9danN07rFFK1+5sXLdEkkxAbpplGac7oO3THRyLk1qVwXriPlCPfOhBkWd/HzV WRUMiqs5FCe0VJpGNbYSXqAWy9EkXJpffltlOJTq0KOy8KHCf+Ba3TaO6VheU8cCkHC2 Edh2AMAxu055UgykHq2jKV1Dhn7QkjcPeCxquVK+Zns9fiAwOijWkOhM8/Rb4hv3IKVP dXINNvlrYtV0P1MXgusrVKD8jm21WO/GgSKLMZ3V4LrdmSBb704Y+mpERS7RGop/twEU kjEhBfrJwvIi9JCtP6X5jcOb75rcR/EMUWSGSkrTgSKQRXDYPeZe0Q5BCPyAxLJAgR1a J4fg== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:from:subject:to:cc:references:openpgp:autocrypt :message-id:date:user-agent:mime-version:in-reply-to :content-transfer-encoding:content-language; bh=vNCIE9RLLOS+CUtVyqQGQrh4o+wgdNWvFkxRuvBn/ck=; b=pvBUNRmsH9ybIHvAY48eh6kzbgDA8rim22F0CIkrIqTg6+717yFJ2FQHwUiEDcK15s DDtDkcO3BNW5JpeIiz6nWul8qPGI5nJfgQgzfWIxqWvLPD3zGMiPiNBnCJTkrwCac0OK R3dw8RTCiHICos8DjBrwnQ1KW3UDQvl1iG9fGw4/mhFdzx5RQKpabYlxUD1DFpH7n8uO mEs5mtgp1ydA6rxPiX1gzuhI1uUWAzwpnRs9Wj1vsEB93tgJiZT6GztRqVuslNfqSwn8 1qHRPakuphiG5kITNRWbmh8wzKnQpv5QOOKmqQaavFR3hqxqGtafHdkvOi4QcK1RE1pL wjVg== X-Gm-Message-State: APjAAAVKk2ZeEKkVNKYaXiJ9ZuGySq0t7TGPgA93zMcXcDP3yG5fUOzI nW31/thOGokDDu5rEjO9X6If X-Google-Smtp-Source: APXvYqzab7GrUrHs58QXvBQmYfxyqboaa9FOyHtdHLbD4YpVK5Nx11yv6LNyvYn+4SI67GK870RKTQ== X-Received: by 2002:a81:9801:: with SMTP id p1mr12639257ywg.259.1551663472746; Sun, 03 Mar 2019 17:37:52 -0800 (PST) Received: from [192.168.10.146] ([98.122.175.38]) by smtp.gmail.com with ESMTPSA id z11sm1614516ywz.98.2019.03.03.17.37.51 (version=TLS1_3 cipher=AEAD-AES128-GCM-SHA256 bits=128/128); Sun, 03 Mar 2019 17:37:52 -0800 (PST) From: Andrew Dunstan X-Google-Original-From: Andrew Dunstan Subject: Re: jsonpath To: Tomas Vondra , Alexander Korotkov , Nikita Glukhov Cc: Andres Freund , Oleg Bartunov , Michael Paquier , Stas Kelvich , PostgreSQL-development , Thomas Munro , David Steele , Tom Lane , Robert Haas , Pavel Stehule References: <9f5f1247-29f4-17cd-edd9-38e9bcd95b14@postgrespro.ru> <20190130022826.of7w6xv5lbvzqxfp@alap3.anarazel.de> <957ee2ff-f9a6-0ba1-13e2-9c4d320f63ac@2ndquadrant.com> Openpgp: preference=signencrypt Autocrypt: addr=andrew.dunstan@2ndQuadrant.com; prefer-encrypt=mutual; keydata= xsBNBE7KWFkBCAClridxur2AIc7eW2AR7izbfp3EnNefie2HbLF0izW5Ik5UjX2HBXBx4syI gY6b0ugohXrr274+baoAlvSbq6cAoQuEVrk5IZFzt20b1Xkx65FwGSEj526yiKLocqkJceSq Xr9xcA5SGY+FZv441chh5SU92v4q6z+6LPpoHOh97ptAVXZYNTtU0LevyvD5lja0TzbvJm6C eFXitJfnm1pLEr0DGJCR/iUOl/N62Kh4855zZC7NHIjQHPOvV5Stz/l5ilDhvGVk+xkXFPys SjZoUr1rXhYLpiyi5sR0X9FHXT0KnGuz1F5ERO7ZTLSSQ6fJwPj6gOk9K+vvoKvoeql5ABEB AAHNL0FuZHJldyBEdW5zdGFuIDxhbmRyZXcuZHVuc3RhbkAybmRRdWFkcmFudC5jb20+wsCY BBMBAgBCAhsDBgsJCAcDAgYVCAIJCgsEFgIDAQIeAQIXgAUJDyV6hBYhBOQ+WEYd/Hy/RGkV pZn6f8tZ/DuBBQJcH/EVAhkBAAoJEJn6f8tZ/DuB7BEH/iDWZEbVft2m2MT6SPjARzTupt/l xLLZ/Cl6n2US2hov5+fBbnR5xvECk/YCOfG9ICvKNlpFjceqNLRKStd8cmndnI+kDw91uNM2 hpL4aJMeW65XCHvqXlOLSwv5chBpXz9NG7FMaJ+q+59sWEWjcTNmjXgkEHn53y+1pc7nSLDe cr5ZI1aB3nGXRm1SoDY5PYZkUKMykW+YBZwgcs/Q5tRaE+siN7DKbz8E628+PerwAkmHPVXN MdJFD6gs4S0gDFA8IxcyIwZU2v4By+brzcJ9Se3FK5BYxBDHtaYZxgSrJAvOUOrLIZPQTQfL TtnVs3C3JTfrxCH1ceHtnA6dRuTOwE0ETspYWQEIANGc4zQULOxhbqO2dyD51YhqCNRmm9oK Waqf+wmW4tpDe/VVcxAnNizd4LWCHfzpb5cHAtGkOPePMfzWVf6nvdF7d3eglbtf59+zG7O7 llV0xSSoFiieQBsrGvqDInXYX/4mRRXMtyhM353/tixC9RWLs1oofyYmCPPXXY7h9R7en3B8 BoVrRFcdzlIY/NFNhFGW/9dkEiGjgna2Rk6e15kln4ZvFBWUg23p93w/pqXcxY6+k/8TEk+C 4R+M6w7o2PLGOjdZ+kPiUcw5H85zf/yZJwQXzisXaNduwWB6Vads9YC9dj6kPR1c4VGRqAaY L++LAEOqrlvm2TvqQqZRtnEAEQEAAcLAZQQYAQIADwIbDAUCXA6fpAUJDyV6xAAKCRCZ+n/L Wfw7geU4B/9vFFsVmWxerDWgNjyiK80zIPmlw/iwdUlU6FIu0JWLMg4093kvxBs7RMZV9hBq n3ekBvD4IvFsVLJrw9qzSI2FH3UeYy5WXpEs01Ppia60NOlvRDqXbryzuvfe+iYo6bVP3Ikr TPTNYL/BePUTD2DPvSI82SbGTyzuA7SJv6NRqqQDMIy1fU6KyQFLmQJp/QJyhKWzm9jWh8ee w8jVaoMY0Kbq5N7RqisEx1Lu/Iw646UphdYzQNymf+kbiU5Kf4I6DhzV8w9sie1Bo1juNj3I c5/fFJsmxljbnaDbXPcnFsur1Oo9mIHFakgWgOBMuxoWfjONiLjjLh/9+ZIqSSLX Message-ID: Date: Sun, 3 Mar 2019 20:37:50 -0500 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:60.0) Gecko/20100101 Thunderbird/60.3.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit Content-Language: en-MW List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk On 3/3/19 1:08 PM, Tomas Vondra wrote: > > > jsonb_util.c > ============ > > I see we're now handling NaN values in convertJsonbScalar(). Isn't it > actually a bug that we don't do this already? Or is it not needed for > some reason? > JSON standard numerics don't support NaN, Infinity etc., so I assume this can only happen in a jsonpath expression being converted to a jsonb value. If so, the new section  should contain a comment to that effect, otherwise it will be quite confusing. cheers andrew -- Andrew Dunstan https://www.2ndQuadrant.com PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services