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 > mailto:gunnar.bl...@pro-open.de>> > wrote: > > -BEGIN PGP SIGNED MESSAGE- CREATE OR REPLACE FUN

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 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 SECURITY DEFINER > AS

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 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 "locale" is

[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 hig