Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1cBQow-0002Mg-8F for pgsql-hackers@arkaria.postgresql.org; Mon, 28 Nov 2016 18:38:30 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1cBQov-00024f-Mc for pgsql-hackers@arkaria.postgresql.org; Mon, 28 Nov 2016 18:38:29 +0000 Received: from makus.postgresql.org ([2001:4800:1501:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1cBQou-00023n-1Z for pgsql-hackers@postgresql.org; Mon, 28 Nov 2016 18:38:28 +0000 Received: from sub4.mail.dreamhost.com ([69.163.253.135] helo=homiemail-a98.g.dreamhost.com) by makus.postgresql.org with esmtps (TLS1.1:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1cBQor-0006h9-D8 for pgsql-hackers@postgresql.org; Mon, 28 Nov 2016 18:38:26 +0000 Received: from homiemail-a98.g.dreamhost.com (localhost [127.0.0.1]) by homiemail-a98.g.dreamhost.com (Postfix) with ESMTP id F364360002A37; Mon, 28 Nov 2016 10:38:22 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha1; c=relaxed; d=cryptonector.com; h=date :from:to:cc:subject:message-id:references:mime-version :content-type:in-reply-to; s=cryptonector.com; bh=UvWJOfWAUD4axs dAlwRfsXLYcyc=; b=U0oGO0Z9zULAoaTzUN+BEAZN0DPi3SXSAiMah/6GKj5nrP k3uY2OsG0WarfY9EiWJ/BclY+RQuw4IM/q3yiEv834CRPYfFjGlhYsiJHA2P1wMU hJloql8wi/Gt+EQXkEBDxamekyg6oz2Ya9oaS/j7BEPlQikXWmTRSdLxitpj4= Received: from localhost (cpe-70-123-158-140.austin.res.rr.com [70.123.158.140]) (using TLSv1.2 with cipher ECDHE-RSA-AES128-GCM-SHA256 (128/128 bits)) (No client certificate requested) (Authenticated sender: nico@cryptonector.com) by homiemail-a98.g.dreamhost.com (Postfix) with ESMTPSA id 662CA60002A26; Mon, 28 Nov 2016 10:38:22 -0800 (PST) Date: Mon, 28 Nov 2016 12:38:20 -0600 From: Nico Williams To: Christian Convey Cc: Pavel Stehule , Tom Lane , "pgsql-hackers@postgresql.org" Subject: Re: Tackling JsonPath support Message-ID: <20161128183819.GB11117@localhost> References: <20681.1479057226@sss.pgh.pa.us> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: User-Agent: Mutt/1.5.24 (2015-08-30) X-Pg-Spam-Score: -1.5 (-) 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 I wonder what it might take to integrate jq[1] (via libjq) with PostgreSQL... The internal representation of JSON data is bound to be completely different, no doubt, but jq is a fantastic language, akin to XPath and XSLT combined, but with nice syntax. [1] https://stedolan.github.io/jq (note: jq is NOT JQuery) Nico -- -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers