diff options
Diffstat (limited to 'contrib/jsonb_plperl/sql/jsonb_plperlu.sql')
| -rw-r--r-- | contrib/jsonb_plperl/sql/jsonb_plperlu.sql | 4 |
1 files changed, 2 insertions, 2 deletions
diff --git a/contrib/jsonb_plperl/sql/jsonb_plperlu.sql b/contrib/jsonb_plperl/sql/jsonb_plperlu.sql index 9c0c083c99c..339486ddb6f 100644 --- a/contrib/jsonb_plperl/sql/jsonb_plperlu.sql +++ b/contrib/jsonb_plperl/sql/jsonb_plperlu.sql @@ -38,7 +38,7 @@ CREATE FUNCTION testInf() RETURNS jsonb LANGUAGE plperlu TRANSFORM FOR TYPE jsonb AS $$ -$val = 0 + 'Inf'; +$val = 9**9**9; # we assume this will overflow to +Inf return $val; $$; @@ -49,7 +49,7 @@ CREATE FUNCTION testNaN() RETURNS jsonb LANGUAGE plperlu TRANSFORM FOR TYPE jsonb AS $$ -$val = 0 + 'NaN'; +$val = sin(9**9**9); # we assume sin(inf) will yield NaN return $val; $$; |