how to correctly cast json value to text?

Pavel Stehule <pavel.stehule@gmail.com>

From: Pavel Stehule <pavel.stehule@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2021-05-03T09:15:08Z
Lists: pgsql-hackers
Hi

I am testing a new subscripting interface for jsonb, and I found one issue.

DO $$
DECLARE v jsonb;
BEGIN
  v['a'] = '"Ahoj"';
  RAISE NOTICE '%', v['a'];
END;
$$;
NOTICE:  "Ahoj"
DO

When I use this interface for reading, the jsonb type is returned. What is
the correct way for casting from jsonb text to text value? I would not
double quotes inside the result. Cast to text doesn't help. For operator
API we can use "->>" symbol. But we have nothing similar for subscript API.

Regards

Pavel