Re: [GENERAL] Unexpected function behaviour with NULL and/or default NULL parameters

2015-05-06 Thread David G. Johnston
On Wednesday, May 6, 2015, Gunnar Nick Bluth gunnar.bl...@pro-open.de wrote: -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, I'm experiencing odd behaviour with a function I wrote yesterday. Background: function is supposed to deliver some terms and conditions from a table; when the

Re: [GENERAL] Unexpected function behaviour with NULL and/or default NULL parameters

2015-05-06 Thread David G. Johnston
Wednesday, May 6, 2015, Gunnar Nick Bluth gunnar.bl...@pro-open.de wrote: -BEGIN PGP SIGNED MESSAGE- CREATE OR REPLACE FUNCTION public.get_current_tac(userid bigint, sessionid uuid, locale character varying, OUT current_tac json) RETURNS json LANGUAGE sql IMMUTABLE STRICT

[GENERAL] Unexpected function behaviour with NULL and/or default NULL parameters

2015-05-06 Thread Gunnar Nick Bluth
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Hello, I'm experiencing odd behaviour with a function I wrote yesterday. Background: function is supposed to deliver some terms and conditions from a table; when the locale is found, deliver the highest version of that, otherwise, deliver the

Re: [GENERAL] Unexpected function behaviour with NULL and/or default NULL parameters

2015-05-06 Thread Gunnar Nick Bluth
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Am 06.05.2015 um 09:57 schrieb David G. Johnston: Ooops, accidentaly replied to David directly... Wednesday, May 6, 2015, Gunnar Nick Bluth gunnar.bl...@pro-open.de mailto:gunnar.bl...@pro-open.de wrote: -BEGIN PGP SIGNED MESSAGE-