7,613
edits
Changes
Jump to navigation
Jump to search
→Python Functions
EXPLAIN ANALYZE SELECT * FROM x;
==Perl Functions==
PLPerl was installed into Template1 (and hence all new databases) when the server was first set up.
An example perl function is:
<nowiki>
CREATE OR REPLACE FUNCTION getint (text) RETURNS int AS $$
if ($_[0]) {
my $var=$_[0];
if ($var=~/^\d\d\d\d\d\d\d+$/) {
return 1;
}
return undef;
}
return undef;
$$ LANGUAGE plperl;
</nowiki>
==Python Functions==
