News for hackers. Stuff that matters.
Re:Better JSON in Postgres with PostgreSQL 14 by zeroimpl on Tuesday June 01, 2021 @07:13PM (#27362680)
Anybody know if there any performance/query plan differences between the following?

    WHERE details->'attributes'->>'color' = 'neon yellow'
And

    WHERE details['attributes']['color'] = '"neon yellow"'
Re:Better JSON in Postgres with PostgreSQL 14 by rcv on Tuesday June 01, 2021 @09:12PM (#27363630)
> While I wouldn't recommend simply using the subscript format everywhere in your application due to it not always leveraging indexes...

I assumed that the subscript format was basically preprocessed into the arrow format, but this kind of implies that it's not. It's too bad the point isn't more clear here as I'm curious as well.