diff options
Diffstat (limited to 'contrib/jsonb_plperl')
-rw-r--r-- | contrib/jsonb_plperl/expected/jsonb_plperl.out | 13 | ||||
-rw-r--r-- | contrib/jsonb_plperl/expected/jsonb_plperlu.out | 13 | ||||
-rw-r--r-- | contrib/jsonb_plperl/sql/jsonb_plperl.sql | 12 | ||||
-rw-r--r-- | contrib/jsonb_plperl/sql/jsonb_plperlu.sql | 12 |
4 files changed, 2 insertions, 48 deletions
diff --git a/contrib/jsonb_plperl/expected/jsonb_plperl.out b/contrib/jsonb_plperl/expected/jsonb_plperl.out index 79d53e5e50f..99a2e8e135d 100644 --- a/contrib/jsonb_plperl/expected/jsonb_plperl.out +++ b/contrib/jsonb_plperl/expected/jsonb_plperl.out @@ -39,17 +39,6 @@ SELECT testSVToJsonb(); 1 (1 row) --- unsupported (for now) -CREATE FUNCTION testRegexpToJsonb() RETURNS jsonb -LANGUAGE plperl -TRANSFORM FOR TYPE jsonb -AS $$ -my $a = qr/foo/; -return ($a); -$$; -SELECT testRegexpToJsonb(); -ERROR: cannot transform this Perl type to jsonb -CONTEXT: PL/Perl function "testregexptojsonb" -- this revealed a bug in the original implementation CREATE FUNCTION testRegexpResultToJsonb() RETURNS jsonb LANGUAGE plperl @@ -218,4 +207,4 @@ SELECT roundtrip('{"1": {"2": [3, 4, 5]}, "2": 3}'); \set VERBOSITY terse \\ -- suppress cascade details DROP EXTENSION plperl CASCADE; -NOTICE: drop cascades to 7 other objects +NOTICE: drop cascades to 6 other objects diff --git a/contrib/jsonb_plperl/expected/jsonb_plperlu.out b/contrib/jsonb_plperl/expected/jsonb_plperlu.out index e842a03396c..8053cf6aa80 100644 --- a/contrib/jsonb_plperl/expected/jsonb_plperlu.out +++ b/contrib/jsonb_plperl/expected/jsonb_plperlu.out @@ -39,17 +39,6 @@ SELECT testSVToJsonb(); 1 (1 row) --- unsupported (for now) -CREATE FUNCTION testRegexpToJsonb() RETURNS jsonb -LANGUAGE plperlu -TRANSFORM FOR TYPE jsonb -AS $$ -my $a = qr/foo/; -return ($a); -$$; -SELECT testRegexpToJsonb(); -ERROR: cannot transform this Perl type to jsonb -CONTEXT: PL/Perl function "testregexptojsonb" -- this revealed a bug in the original implementation CREATE FUNCTION testRegexpResultToJsonb() RETURNS jsonb LANGUAGE plperlu @@ -218,4 +207,4 @@ SELECT roundtrip('{"1": {"2": [3, 4, 5]}, "2": 3}'); \set VERBOSITY terse \\ -- suppress cascade details DROP EXTENSION plperlu CASCADE; -NOTICE: drop cascades to 7 other objects +NOTICE: drop cascades to 6 other objects diff --git a/contrib/jsonb_plperl/sql/jsonb_plperl.sql b/contrib/jsonb_plperl/sql/jsonb_plperl.sql index 9993132ef0d..8b0a8764afa 100644 --- a/contrib/jsonb_plperl/sql/jsonb_plperl.sql +++ b/contrib/jsonb_plperl/sql/jsonb_plperl.sql @@ -34,18 +34,6 @@ $$; SELECT testSVToJsonb(); --- unsupported (for now) -CREATE FUNCTION testRegexpToJsonb() RETURNS jsonb -LANGUAGE plperl -TRANSFORM FOR TYPE jsonb -AS $$ -my $a = qr/foo/; -return ($a); -$$; - -SELECT testRegexpToJsonb(); - - -- this revealed a bug in the original implementation CREATE FUNCTION testRegexpResultToJsonb() RETURNS jsonb LANGUAGE plperl diff --git a/contrib/jsonb_plperl/sql/jsonb_plperlu.sql b/contrib/jsonb_plperl/sql/jsonb_plperlu.sql index ab7d2e76e87..9287f7672f7 100644 --- a/contrib/jsonb_plperl/sql/jsonb_plperlu.sql +++ b/contrib/jsonb_plperl/sql/jsonb_plperlu.sql @@ -34,18 +34,6 @@ $$; SELECT testSVToJsonb(); --- unsupported (for now) -CREATE FUNCTION testRegexpToJsonb() RETURNS jsonb -LANGUAGE plperlu -TRANSFORM FOR TYPE jsonb -AS $$ -my $a = qr/foo/; -return ($a); -$$; - -SELECT testRegexpToJsonb(); - - -- this revealed a bug in the original implementation CREATE FUNCTION testRegexpResultToJsonb() RETURNS jsonb LANGUAGE plperlu |