Postgres Pro
Downloads
Home   >   mailing lists

nondeterministic collations and statistics and pattern matching - Mailing list pgsql-docs

From PG Doc comments form
Subject nondeterministic collations and statistics and pattern matching
Date
Msg-id 160201076591.708.3970784784508799676@wrigleys.postgresql.org
Whole thread Raw
Responses Re: nondeterministic collations and statistics and pattern matching  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-docs
Tree view 
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/12/collation.html
Description:

If exists statistic with nondeteministic collation inherited from column
collation then using pattern matching with collation will give an error.
There is no information about it. ((
I have seen this thread
https://www.postgresql.org/message-id/flat/CAAFmbbOvfi%3DwMM%3D3qRsPunBSLb8BFREno2oOzSBS%3DmzfLPKABw%40mail.gmail.com
But I can't apply this patch for some reasons.
If I knew about the problem I would not use nondeterministic collations and
choose another way.

pgsql-docs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Forgotten quote signs in description of "array value as a literal constant"
Next
From: Tom Lane
Date:
Subject: Re: nondeterministic collations and statistics and pattern matching