PostgreSQL jsonからレコードを作成する

json_to_record(jsonデータ) AS句;

jsonb_to_record(jsonbデータ) AS句;

SELECT
  *
FROM
  json_to_record(
    '{"name": "Tom", "age": 20, "address": ["tokyo", "japan"]}'
  ) AS x(name TEXT, age INT, address TEXT[]);

SELECT
  *
FROM
  json_to_record(
    '{"name": "Tom", "age": 20, "address": ["tokyo", "japan"]}'
  );

ERROR:  "record"を返す関数では列定義リストが必要です
LINE 4:   json_to_record(
          ^
SQL 状態: 42601
文字: 19

CREATE TYPE address as (country TEXT, city TEXT);

SELECT
  *
FROM
  jsonb_to_record(
    '{"address": {"country": "jp", "city": "tokyo"}}'
  ) AS x(address address);