doc: guidance on SQL/JSON functions vs jsonpath operators - Mailing list pgsql-hackers

From Florents Tselai
Subject doc: guidance on SQL/JSON functions vs jsonpath operators
Date
Msg-id CA+v5N40ChG-vgY_WeNKPdVWgAhn=BwBbT=HCuO0QUGW79W_w7g@mail.gmail.com
Whole thread Raw
List pgsql-hackers
While reading the docs for the SQL/JSON functions added in 17, 
I noticed that the current text provides no guidance on when to prefer these new functions over the existing jsonpath operators.

I was thinking of something like the attached patch, 
which introduces a Tip and a Note to clarify the distinction 
(focusing on portability/error-handling vs. conciseness/indexing).  

PS: Tbh, the documentation around these PG17 additions is currently quite dense. It likely needs more comprehensive content - which I may provide soon - but this seemed like an obvious first step.



Attachment

pgsql-hackers by date:

Previous
From: Lukas Fittl
Date:
Subject: Re: Reduce timing overhead of EXPLAIN ANALYZE using rdtsc?
Next
From: Jim Jones
Date:
Subject: Re: display hot standby state in psql prompt