bhmj / pg-api Goto Github PK

Hi.

why first parameter in function is always 0??

Ubuntu 20.04
Postgres 12

function hello (have on first input parameter USER_ID

-- FUNCTION: api.hello_get(integer, json)

-- DROP FUNCTION IF EXISTS api.hello_get(integer, json);

CREATE OR REPLACE FUNCTION api.hello_get(
user_id integer,
_data json)
RETURNS json
LANGUAGE 'plpgsql'
COST 100
VOLATILE PARALLEL UNSAFE
AS $BODY$
declare
_str text;
begin
_str := 'Hello there, '||coalesce(_data->>'name', 'stranger')||'!';
return json_build_object('greeting', _str);
end
$BODY$;

ALTER FUNCTION api.hello_get(integer, json)
OWNER TO postgres;

call function from chrome
http://localhost:8088/api/v1/hello/1?name=mike

LOG: {"L":"INFO","T":"2022-05-23T13:13:32.168+0300","C":"service/query.go:61","M":"select * from api.hello_get (0, 1, '{"name":"mike"}')"}

RESPONSE:
pq: function api.hello_get(integer, integer, unknown) does not exist