RE: Ltree pattern matching

2021-11-15 Thread Terry Gilbert
-Original Message- From: Tom Lane Sent: Friday, November 12, 2021 10:37 AM To: Terry Gilbert Cc: pgsql-docs@lists.postgresql.org Subject: Re: Ltree pattern matching EXTERNAL PG Doc comments form writes: > In v12 ltree doc (I've not checked other versions) "The behavior of %

Re: Ltree pattern matching

2021-11-12 Thread Tom Lane
PG Doc comments form writes: > 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 wo

Ltree pattern matching

2021-11-12 Thread PG Doc comments form
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_ba