Do you know a json_populate_record alternative method to create a ROW with a named field notation?

Поиск
Список
Период
Сортировка
От Stéphane Klein
Тема Do you know a json_populate_record alternative method to create a ROW with a named field notation?
Дата
Msg-id CADKxhpesteVU7GiMWqUbMKsTiRzbeXxoNGR42Hv9K7L0cduFqQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Do you know a json_populate_record alternative method to create a ROW with a named field notation?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hello,

In this example:

```
CREATE TYPE contact AS (
   firstname VARCHAR,
   lastname VARCHAR
);

postgres=# SELECT json_populate_record(NULL::contact,
postgres(#   '{
postgres'#      "firstname": "John",
postgres'#      "lastname": "Doe"
postgres'#    }'
postgres'# );
 json_populate_record
----------------------
 (John,Doe)
(1 row)
```

**Question:** do you know a method like json_populate_record (https://www.postgresql.org/docs/13/functions-json.html), which allows creating a `ROW` with named field notation without using a json format?

I know the `ROW` syntax expression:

```
postgres=# SELECT ROW('John', 'Doe')::contact;
    row
------------
 (John,Doe)
(1 row)
```

But I didn't find a `ROW` constructors (https://www.postgresql.org/docs/13/sql-expressions.html#SQL-SYNTAX-ROW-CONSTRUCTORS) syntax allowing a named field notation.

Best regards,  
Stéphane
--

В списке pgsql-general по дате отправления:

Предыдущее
От: Susan Hurst
Дата:
Сообщение: FDW to postGIS Database
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Do you know a json_populate_record alternative method to create a ROW with a named field notation?