How to get position in array with JSONPath

From: Pavel Stehule <pavel(dot)stehule(at)gmail(dot)com>
To: PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org>
Cc: Nikita Glukhov <n(dot)gluhov(at)postgrespro(dot)ru>, Oleg Bartunov <obartunov(at)gmail(dot)com>
Subject: How to get position in array with JSONPath
Date: 2020-09-13 06:22:14
Message-ID: CAFj8pRAkJMR6753=ynmdBcz3EJ6dAiACU5PQj=nAUza6MqD6SA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi

I try to solve issue
https://stackoverflow.com/questions/63864906/plpgsql-parse-json-in-parameter-and-compose-json-out-parameter
with JSONPath and I have a problem to get index of some value in array. Is
it possible with JSONPath?

Regards

Pavel

Browse pgsql-hackers by date

  From Date Subject
Next Message Masahiko Sawada 2020-09-13 08:36:09 Re: Transactions involving multiple postgres foreign servers, take 2
Previous Message Tom Lane 2020-09-12 22:00:07 Re: recovering from "found xmin ... from before relfrozenxid ..."