summaryrefslogtreecommitdiffstats
path: root/src/pl/plperl/sql/plperlu.sql
blob: be43df5d90a6e1cc275609cda6035d937781b1f6 (plain)
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
-- Use ONLY plperlu tests here. For plperl/plerlu combined tests
-- see plperl_plperlu.sql

-- This test tests setting on_plperlu_init after loading plperl
LOAD 'plperl';

-- Test plperl.on_plperlu_init gets run
SET plperl.on_plperlu_init = '$_SHARED{init} = 42';
DO $$ warn $_SHARED{init} $$ language plperlu;

--
-- Test compilation of unicode regex - regardless of locale.
-- This code fails in plain plperl in a non-UTF8 database.
--
CREATE OR REPLACE FUNCTION perl_unicode_regex(text) RETURNS INTEGER AS $$
  return ($_[0] =~ /\x{263A}|happy/i) ? 1 : 0; # unicode smiley
$$ LANGUAGE plperlu;