user-defined function in Perl or Tcl ???

Started by PG Bug reporting formover 4 years ago4 messagesdocs
Jump to latest
#1PG Bug reporting form
noreply@postgresql.org

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.

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: PG Bug reporting form (#1)
Re: user-defined function in Perl or Tcl ???

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

#3Nikolay Samokhvalov
samokhvalov@gmail.com
In reply to: Tom Lane (#2)
Re: user-defined function in Perl or Tcl ???

Curious: why plv8 is still not in the core distro?

(apologies for top posting)

On Fri, Jul 16, 2021 at 6:35 AM Tom Lane <tgl@sss.pgh.pa.us> wrote:

Show quoted text

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

#4Bruce Momjian
bruce@momjian.us
In reply to: Nikolay Samokhvalov (#3)
Re: user-defined function in Perl or Tcl ???

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.