News for hackers. Stuff that matters.
Re:Using PostgreSQL’s JSONB for NoSQL (2019) [video] by paulryanrogers on Sunday September 05, 2021 @10:33AM (#28424624)
Does PostgreSQL have standard operators yet? Last I checked they only had the Pg specific ones, which predate the SQL standard. (Same for SQL/PSM sadly.)
Re:Using PostgreSQL’s JSONB for NoSQL (2019) [video] by simonw on Sunday September 05, 2021 @10:51AM (#28424755)
PostgreSQL 14 is currently in beta and adds JSON subscripting: https://www.postgresql.org/docs/14/datatype-json.html#JSONB-...
Re:Using PostgreSQL’s JSONB for NoSQL (2019) [video] by mdaniel on Sunday September 05, 2021 @12:33PM (#28425547)
Do you have a link to the standard operators you mean? I know they support [SQL/JSON path function](https://www.postgresql.org/docs/12/functions-json.html#FUNCT...) but as for the operators, I only know of their own which predate the standard