Thread: functions-matching.html: Tip says use "Per or Tcl ... ?

functions-matching.html: Tip says use "Per or Tcl ... ?

From
PG Doc comments form
Date:
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

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

I think Perl or Tcl are not the common choice today.

AFAIK Python is quite popular, and they have a good regex implementationd,
too.

Re: functions-matching.html: Tip says use "Per or Tcl ... ?

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

> I think Perl or Tcl are not the common choice today.
> AFAIK Python is quite popular, and they have a good regex implementationd,
> too.

If Python had a trusted PL variant, I'd be happy to recommend that here.
But as long as we only have plpythonu, it's pretty hard to recommend
it for run-of-the-mill tasks like pattern matching.

(The lack of plain plpython isn't our fault; it's that Python has
no sandboxing mechanism.)

            regards, tom lane