Hi, I'm trying to extract text from a jsonb 'string'. Simply casting gives me the string wrapped in quotes:
foo=# select '"foo"'::jsonb::text; text ------- "foo" (1 row) This, of course, makes kind of sense, since it /is/ the JSON's textual representation. What is the canonical way to get at the string's content itself? I've found out that one can treat a string singleton as if it were an array: foo=# select '"foo"'::jsonb ->> 0; ?column? ---------- foo (1 row) which conveniently returns the right type. My question: can I rely on that, or am I missing a much more obvious option? (I try to stay compatible down to PostgreSQL 11, 9 when possible. Conservative customers and that). Thanks for any insights, cheers -- tomás
signature.asc
Description: Digital signature
