Alexander Farber <alexander(dot)farber(at)gmail(dot)com> writes:
> ERROR: function jsonb_insert(jsonb, unknown, integer) does not exist
> LINE 1: SELECT JSONB_INSERT(_user, '{uid}', _uid)
> ^
> HINT: No function matches the given name and argument types. You might
> need to add explicit type casts.
> QUERY: SELECT JSONB_INSERT(_user, '{uid}', _uid)
> CONTEXT: PL/pgSQL function words_get_user(jsonb) line 44 at assignment
I think it'd work to do
JSONB_INSERT(_user, '{uid}', to_jsonb(_uid));
The third argument has to be jsonb, not something else.
regards, tom lane