Menu

#1 immutable functions are not created as immutable

open
nobody
None
5
2004-10-04
2004-10-04
No

For example:

CREATE OR REPLACE FUNCTION rankeable(int8, int8)
RETURNS bool AS
'
select case
when $1 > 0 or $2 > 0 then
true
else
false
end;'
LANGUAGE 'sql' IMMUTABLE;

is not created as "immutable" on the output diff

thanks in advance

Discussion


Log in to post a comment.

MongoDB Logo MongoDB