ts_debug() style functions for jsonpath debugging

From: Alastair McKinley <a(dot)mckinley(at)analyticsengines(dot)com>
To: "pgsql-general(at)lists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: ts_debug() style functions for jsonpath debugging
Date: 2020-06-08 11:36:52
Message-ID: PR1PR02MB53406CCEBAF9BB7B1BDEF2DDE3850@PR1PR02MB5340.eurprd02.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hello everyone,

I am working with jsonpaths heavily and was wondering if there is any method for debugging a jsonpath expression in a similar method to ts_debug() for text search?

Essentially what I would like to do is debug the splitting of a path into tokens or logical components using the same parser as postgres itself.

Is there any method currently available that could be exposed at the SQL layer to inspect jsonpath expressions?

Best regards,

Alastair

Browse pgsql-general by date

  From Date Subject
Next Message Paul Förster 2020-06-08 11:42:50 Re: Postgres 12 RLS
Previous Message Laura Smith 2020-06-08 10:46:11 Re: Postgres 12 RLS