From: | awasarax(at)yandex(dot)ru |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #13768: JSONB concat |
Date: | 2015-11-11 11:50:02 |
Message-ID: | 20151111115002.2643.11338@wrigleys.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged on the website:
Bug reference: 13768
Logged by: Roman
Email address: awasarax(at)yandex(dot)ru
PostgreSQL version: 9.5beta1
Operating system: Windows (7, Server 2008 r2)
Description:
if "d" is null then return = null
else
return <> null
CREATE OR REPLACE FUNCTION userfunc(jsonb)
RETURNS jsonb AS
$BODY$
DECLARE
r jsonb = null;
d jsonb = null;
BEGIN
SELECT to_json(users.*) INTO r FROM users WHERE ///////;
RETURN r||d; -- return null
END;
$BODY$
LANGUAGE plpgsql VOLATILE;
From | Date | Subject | |
---|---|---|---|
Next Message | konst583 | 2015-11-11 15:10:04 | BUG #13769: SELECT ... FROM a JOIN b FOR UPDATE a; BREAKS SNAPSHOT |
Previous Message | David G. Johnston | 2015-11-10 20:51:48 | Re: BUG #13767: EXECUTE querytext USING value1, value2, value3 (Edge case?) |