Hacker News new | ask | show | jobs
by derefr 1859 days ago
You could also take advantage of PG's function/field equivalence:

           -- equivalent to deref_jsonb('"sdfasdf"'::jsonb)
    select ('"sdfasdf"'::jsonb).deref_jsonb;
(I'd suggest naming the function "inner_text", for familiarity to JS devs :P)
1 comments

Oh my. :) There's always some quirky little thing to learn about PostgreSQL, lol.