News for hackers. Stuff that matters.
Re:Using PostgreSQL for JSON Storage by thisgoodlife on Thursday April 30, 2020 @02:46PM (#23034534)
I don't like those seemingly arbitrary json operators. ->> #>> ?& @>. IMHO, they'd be easier to understand with proper function names.
Re:Using PostgreSQL for JSON Storage by baq on Thursday April 30, 2020 @03:10PM (#23034852)
They’d have to invent a syntax for infix function calls akin to Haskell’s backticks which other people would complain about.

(I’m happy we don’t have to write queries in yaml, only half joking.)

Re:Using PostgreSQL for JSON Storage by wayneftw on Thursday April 30, 2020 @06:43PM (#23037097)
Re:Using PostgreSQL for JSON Storage by eyelidlessness on Thursday April 30, 2020 @09:40PM (#23038299)
And Postgres has a ton of `JSON_` and `JSONB_` functions, so the weird operators are even more baffling.
Re:Using PostgreSQL for JSON Storage by eyelidlessness on Thursday April 30, 2020 @09:39PM (#23038294)
Why have infix anything? Functions have names and they're always the first symbol in a function call. SQL also has a convention of using `PLAIN ENGLISH WORDS` which declaratively describe the result set or operation. The weird JSONB operators are just... way out of place.