Date: Tue, 29 Nov 2016 10:28:38 -0600
From: Nico Williams <nico@cryptonector.com>
To: Petr Jelinek <petr@2ndquadrant.com>
Cc: Pavel Stehule <pavel.stehule@gmail.com>,
	Christian Convey <christian.convey@gmail.com>,
	David Fetter <david@fetter.org>,
	PostgreSQL Hackers <pgsql-hackers@postgresql.org>,
	Tom Lane <tgl@sss.pgh.pa.us>
Subject: Re: Tackling JsonPath support
Message-ID: <20161129162837.GF24797@localhost>
References: 
 <CAFj8pRDvKiQ3YcNOCeEcOEy+OKh6LFcazmOe-Tit-gHyv1e+xQ@mail.gmail.com>
 <CAPfS4Zx8v1xx_OoG6n2_K2TthNudGshfkSbk=-__N+1-z8WSwg@mail.gmail.com>
 <20161128162639.GB27143@fetter.org>
 <CAFj8pRCSj4hQ_rOODyPp91asPdiLWLqTDcjJmxwjoaUfH1h_cQ@mail.gmail.com>
 <20161128192343.GD11117@localhost>
 <CAPfS4ZwgHT5FkRm8LE0ucG97e36ziBm0Pc-GkyGC15ksTwVFpw@mail.gmail.com>
 <CAFj8pRAtvZAtA2OBiyZyjf+AC24g6oSuKsbA8uWGZFZOoq=hDw@mail.gmail.com>
 <CAPfS4ZzcAdX6S3389rO-xfULvYuvD6VCACoxNJK=sUmhsnj0ow@mail.gmail.com>
 <CAFj8pRC8FFX9=+yi_im8bBJP0GJrv92hSuoFUH0nft62QLk0oQ@mail.gmail.com>
 <80228378-f5ba-1291-872b-9812e103e37c@2ndquadrant.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <80228378-f5ba-1291-872b-9812e103e37c@2ndquadrant.com>
User-Agent: Mutt/1.5.24 (2015-08-30)
Precedence: bulk
Sender: pgsql-hackers-owner@postgresql.org

On Tue, Nov 29, 2016 at 05:18:17PM +0100, Petr Jelinek wrote:
> Just to add to this, the SQL/JSON proposals I've seen so far, and what
> Oracle, MSSQL and Teradata chose to implement already is basically
> subset of jsonpath (some proposals/implementations also include
> lax/strict prefix keyword on top of that). I think that should give us
> some hint on what the base functionality should look like.

Yes, that'd be base functionality.  You can go above and beyond.

I agree with Pavel that jq could be used as a user-defined function, but
proper integration would be better because it would avoid the need to
format and parse JSON around calls to jq, and also because PG could
compile jq programs when preparing SQL statements.  Besides, the libjq
jv API is *very* nice.

Nico
-- 


-- 
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers