hstore_plperl

Usage example (using the untrusted variant hstore_plperlu to be able to use the Data::Dumper module):

postgres=# CREATE EXTENSION hstore_plperlu CASCADE;
NOTICE:  installing required extension "hstore"
NOTICE:  installing required extension "plperlu"

postgres=# CREATE FUNCTION hello_hstore(hstore)
             RETURNS TEXT
             TRANSFORM FOR TYPE hstore
             LANGUAGE plperlu
           AS $$
             my $params = shift;
           
             use Data::Dumper;
             elog(INFO, Dumper($params));
           
             $params->{message} //= 'world';
           
             return sprintf('hello %s', $params->{message});
           $$;
CREATE FUNCTION

postgres=# SELECT hello_hstore('message=>"universe"');
INFO:  $VAR1 = {
          'message' => 'universe'
        };

  hello_hstore  
----------------
 hello universe
(1 row)

• PostgreSQL documentation: hstore