Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cBTgW-0000qo-CI for pgsql-hackers@arkaria.postgresql.org; Mon, 28 Nov 2016 21:42:00 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cBTgV-0005Vr-VY for pgsql-hackers@arkaria.postgresql.org; Mon, 28 Nov 2016 21:42:00 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cBTgU-0005VF-J3 for pgsql-hackers@postgresql.org; Mon, 28 Nov 2016 21:41:58 +0000 Received: from mail-wj0-x235.google.com ([2a00:1450:400c:c01::235]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cBTgR-00035A-JC for pgsql-hackers@postgresql.org; Mon, 28 Nov 2016 21:41:58 +0000 Received: by mail-wj0-x235.google.com with SMTP id mp19so128532181wjc.1 for ; Mon, 28 Nov 2016 13:41:55 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=2ndquadrant-com.20150623.gappssmtp.com; s=20150623; h=subject:to:references:from:message-id:date:user-agent:mime-version :in-reply-to:content-transfer-encoding; bh=Q3IdvpQ60L+h9PWQxQrNKm1NshAUxovU+qh1hwg9Hds=; b=r20n9Cej2USDOEBPbkFH1Nd51L3dlj6kXhrkCd9pceC5judQYG42bsvYe0xXTDYDVY 3KNziqaJTKdAxtRVbJu9kb5AzPWQwmSh1Fw0tDO6niA7tiQOFv/UCGd0DIHUKIBVispO TqrRyg5dfMTyfhVrG3qN5d+xLPRxcYik3nj+zIRSgqFdxk1r2nZqvwbu7Si6mEcNIIYK bGTQpg33wwWN8Ta9a2opSkTsee4RFjHvVVHE7EE4WVGyga2pICoGkvYw3WPZwWNiHdkJ d49FRSrS15UHuK4yaVmsnnN3rmREE1yunFuf+e/k6VmqFobbFu1kRpD/rPxYbhuuAfi4 zylA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:subject:to:references:from:message-id:date :user-agent:mime-version:in-reply-to:content-transfer-encoding; bh=Q3IdvpQ60L+h9PWQxQrNKm1NshAUxovU+qh1hwg9Hds=; b=RU/DYu0gEwJ0bQsRiBfZr3F+hiROMYzcOlLWpQGMfOi6UQ9lna8NMmhg5C0SOEUDca yDeBHV+tvEqFEuJrjQsE8rA9HK/s91erRNul6+Gkf/hA2CbYbNxQXtWFctQPCaofeLU0 9Er3wIPaoGWlS5TYANET1DG8/nmbfdwFgCTd91lWwNHEPpk9/IBcwUqxJje9+C7nel29 oyPvYxgqVvXHvgrKfenX4RAIG8t1ugJwV/vEnLVi4SXvNCJCZ7uIVpRKG/hTnzoKFQWp ABswOxCVDf9CdcHPyGf09fLkSKbx+ZCXJehvp7x0WK/cA9tCYHK/drdDaXN/sZq+7mVo 8oug== X-Gm-Message-State: AKaTC00w1hXmlCJcj9ZcJ8WhOvJZywmVgcdu80nF7xCpoEgRZIMnb95/P0deHbzx7A9rF3si X-Received: by 10.194.171.66 with SMTP id as2mr24683390wjc.77.1480369313721; Mon, 28 Nov 2016 13:41:53 -0800 (PST) Received: from [192.168.0.105] (150.123.broadband11.iol.cz. [90.178.123.150]) by smtp.gmail.com with ESMTPSA id 138sm30882198wms.20.2016.11.28.13.41.52 (version=TLS1_2 cipher=ECDHE-RSA-AES128-GCM-SHA256 bits=128/128); Mon, 28 Nov 2016 13:41:53 -0800 (PST) Subject: Re: Tackling JsonPath support To: Christian Convey , Pavel Stehule , "pgsql-hackers@postgresql.org" , Tom Lane References: <20681.1479057226@sss.pgh.pa.us> From: Petr Jelinek Message-ID: Date: Mon, 28 Nov 2016 22:41:51 +0100 User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:45.0) Gecko/20100101 Thunderbird/45.4.0 MIME-Version: 1.0 In-Reply-To: Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 8bit X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org On 28/11/16 18:57, Christian Convey wrote: > > On Mon, Nov 28, 2016 at 9:47 AM, Pavel Stehule > wrote > > > I thought by adding my first implementation to "contrib", we could make this functionality available to end-users, even before there was a consensus about what PG's "official" JSON-related operators should have for syntax and semantics. > > > > this time the commiters dislike the contrib dir. It is hard to push > there anything :-(. You can try it, but it can be lost time. > > > ​Thanks for the warning. I'm okay with my patch adding the "json_path" > function to the core PG code.​ > > I would still suggest that we hold off on having my first patch > implement an official JSON-related operator such as "JSON_TABLE". I > would prefer to have my "json_path" function available to users even > before we know how "JSON_TABLE", etc. should behave. > > ​Does that sound reasonable?​ > Hi, just make it extension, not contrib module, there is not much difference between those except contrib is included in distribution. Extensions that provide just functions are easy to integrate into core (that's how some of the existing json functions were added in the past as well). -- Petr Jelinek http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers