Thread: user-defined function in Perl or Tcl ???

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/13/functions-matching.html
Description:

https://www.postgresql.org/docs/current/functions-matching.html

> If you have pattern matching needs that go beyond this, consider writing a
user-defined function in Perl or Tcl.

If you start from scratch today, it is unlikely that you use Perl or Tcl.

I think this message on above page needs an update.

PG Doc comments form <noreply@postgresql.org> writes:
>> If you have pattern matching needs that go beyond this, consider writing a
>> user-defined function in Perl or Tcl.

> If you start from scratch today, it is unlikely that you use Perl or Tcl.

That statement is not that way because we haven't thought about it.

Of the options we provide in the core distro, plpython is less suitable
because it only comes in an untrusted form (for lack of any workable
sandboxing feature in Python).  So plperl or pltcl is what there is.

            regards, tom lane

On Fri, Jul 16, 2021 at 10:56:31PM -0700, Nikolay Samokhvalov wrote:
> Curious: why plv8 is still not in the core distro?
> 
> (apologies for top posting)

plv8 requires a ton of dependencies and is very hard to build.

-- 
  Bruce Momjian  <bruce@momjian.us>        https://momjian.us
  EDB                                      https://enterprisedb.com

  If only the physical world exists, free will is an illusion.