From: | Alexander Farber <alexander(dot)farber(at)gmail(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
Subject: | RETURNS TABLE function returns nothingness |
Date: | 2016-09-02 17:21:15 |
Message-ID: | CAADeyWia3OtjrKONabK=aSUDdPAbdG+8RAef4GtdFsYe4XGRFA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Good evening,
please help me to figure out, why doesn't this simple test function return
a row with 42, NULL values:
CREATE OR REPLACE FUNCTION words_merge_users_2(
IN in_users jsonb,
IN in_ip inet
) RETURNS TABLE (
out_uid integer,
out_banned varchar
) AS
$func$
DECLARE
_user jsonb;
_uids integer[];
_created timestamptz;
_vip timestamptz;
_grand timestamptz;
_banned_until timestamptz;
_banned_reason varchar;
BEGIN
out_uid := 42;
END
$func$ LANGUAGE plpgsql;
Here I call it at PostgreSQL 9.5.4 prompt in MacOS:
# select * from
words_merge_users_2('[{"given":"Abcde","social":1,"auth":"07f0254f5e55413dec7f32c8ef4ee5d3","stamp":1470237061,"female":0,"sid":"11111"}]
'::jsonb, '1.1.1.1'::inet);
out_uid | out_banned
---------+------------
(0 rows)
Thank you (I am probably missing something very obvious)
Alex
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2016-09-02 17:27:04 | Re: RETURNS TABLE function returns nothingness |
Previous Message | Scott Marlowe | 2016-09-02 17:10:35 | Re: What limits Postgres performance when the whole database lives in cache? |