| From: | PG Doc comments form <noreply(at)postgresql(dot)org> |
|---|---|
| To: | pgsql-docs(at)lists(dot)postgresql(dot)org |
| Cc: | terry(dot)gilbert(at)sas(dot)com |
| Subject: | Ltree pattern matching |
| Date: | 2021-11-11 15:40:12 |
| Message-ID: | 163664521217.8082.8625825759427310603@wrigleys.postgresql.org |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-docs |
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/12/ltree.html
Description:
In v12 ltree doc (I've not checked other versions)
"The behavior of % is a bit complicated. It tries to match words rather than
the entire label. For example foo_bar% matches foo_bar_baz but not
foo_barbaz. If combined with *, prefix matching applies to each word
separately, for example foo_bar%* matches foo1_bar2_baz but not
foo1_br2_baz.
I believe foo1 is in error (if I understood the operators), it should be
foo.
Regards
T
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2021-11-11 16:04:47 | Re: text fields and performance for ETL |
| Previous Message | Grega Jesih | 2021-11-11 09:44:37 | RE: text fields and performance for ETL |