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 -- Stéphane Klein <cont...@stephane-klein.info> Homepage: http://stephane-klein.info