3 ms·
You could also take advantage of PG's function/field equivalence: -- equivalent to deref_jsonb('"sdfasdf"'::jsonb) select ('"sdfasdf"'::jsonb).d
by derefr 5y 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)
- megous 5y agoOh my. :) There's always some quirky little thing to learn about PostgreSQL, lol.