From: | Arup Rakshit <ar(at)zeit(dot)io> |
---|---|
To: | "pgsql-general(at)postgresql(dot)org >> PG-General Mailing List" <pgsql-general(at)postgresql(dot)org> |
Subject: | ERROR: type "myrowtype" does not exist |
Date: | 2018-10-26 11:54:04 |
Message-ID: | BB162BE8-658C-4368-987E-8D5A3944232B@zeit.io |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I was reading the json_populate_record function from the official doc https://www.postgresql.org/docs/10/static/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE <https://www.postgresql.org/docs/10/static/functions-json.html#FUNCTIONS-JSON-PROCESSING-TABLE>. The doc mentioned examples are giving me errors
psql (11.0, server 10.5)
Type "help" for help.
aruprakshit=# select * from json_populate_record(null::extype, '{"x":"foo", "y":43, "q": true}');
ERROR: type "extype" does not exist
LINE 1: select * from json_populate_record(null::extype, '{"x":"foo"...
^
aruprakshit=# select * from json_populate_record(null::myrowtype, '{"a": 1, "b": ["2", "a b"], "c": {"d": 4, "e": "a b c"}}');
ERROR: type "myrowtype" does not exist
LINE 1: select * from json_populate_record(null::myrowtype, '{"a": 1…
What does null::extype, null::myrowtype mean here ?
Thanks,
Arup Rakshit
ar(at)zeit(dot)io
From | Date | Subject | |
---|---|---|---|
Next Message | Mike Martin | 2018-10-26 12:22:19 | Shell Command within function |
Previous Message | Bruno Wolff III | 2018-10-26 11:23:14 | Re: Should pg 11 use a lot more memory building an spgist index? |