Re: json_populate_recordset - Mailing list pgsql-general

From Pavel Stehule
Subject Re: json_populate_recordset
Date
Msg-id CAFj8pRAeXRoomwTJYvKfsNbre_H+GUbrhq2z4AsSTCjDRO=OYA@mail.gmail.com
Whole thread Raw
In response to json_populate_recordset  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: json_populate_recordset  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general


2018-06-07 18:51 GMT+02:00 Adrian Klaver <adrian.klaver@aklaver.com>:
From here:

https://www.postgresql.org/docs/10/static/functions-json.html

select * from json_populate_record(null::myrowtype, '{"a": 1, "b": ["2", "a b"], "c": {"d": 4, "e": "a b c"}}')

What is the null::myrowtype doing?

this function uses polymorphic parameters - its some like

create or replace function fx(in anyelement, json) returns anyelement ..

output polymorphic value requires minimally one input polymorphic value for type specification. Postgres has not possibility to pass only datatype - so pattern null:type is used instead.

Regards

Pavel
 


Thanks,
--
Adrian Klaver
adrian.klaver@aklaver.com


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: json_populate_recordset
Next
From: Jean Claude
Date:
Subject: Service pgpool