Re: Lower or Upper case for F.33. pg_trgm

2022-08-16 Thread Tom Lane
Daniel Gustafsson writes: > Looking at this I'm leaning towards paring down the diff posted upthread with > pretty much this, I think that will provide value while avoid causing > confusion. WFM. > As a related side note, there are four instances of "case insensitive{ly}" in > the docs with all

Re: Lower or Upper case for F.33. pg_trgm

2022-08-16 Thread Daniel Gustafsson
> On 16 Aug 2022, at 15:53, Tom Lane wrote: > > Erik Rijkers writes: >> (bluntly stating 'similarity comparisons are case-insensitive' - >> although I'm not really sure..) > > Perhaps like "similarity comparisons are case-insensitive in a > standard build of pg_trgm", if you want to nod to

Re: Lower or Upper case for F.33. pg_trgm

2022-08-16 Thread Marc M.
Sounds good to me. Am Di., 16. Aug. 2022 um 15:53 Uhr schrieb Tom Lane : > Erik Rijkers writes: > > (bluntly stating 'similarity comparisons are case-insensitive' - > > although I'm not really sure..) > > Perhaps like "similarity comparisons are case-insensitive in a > standard build of

Re: Lower or Upper case for F.33. pg_trgm

2022-08-16 Thread Tom Lane
Erik Rijkers writes: > (bluntly stating 'similarity comparisons are case-insensitive' - > although I'm not really sure..) Perhaps like "similarity comparisons are case-insensitive in a standard build of pg_trgm", if you want to nod to the existence of a compile option without going into detail.

Re: Lower or Upper case for F.33. pg_trgm

2022-08-16 Thread Erik Rijkers
Op 16-08-2022 om 13:46 schreef Daniel Gustafsson: On 16 Aug 2022, at 12:54, Erik Rijkers wrote: Op 16-08-2022 om 12:36 schreef Daniel Gustafsson: On 16 Aug 2022, at 12:17, PG Doc comments form wrote: I have a question regarding the trigram algorithm and I can not find any information about

Re: Lower or Upper case for F.33. pg_trgm

2022-08-16 Thread Marc M.
Thanks for your fast response. Is this a question for me? I am fine with a short hint regarding the default. A link to another documentation is also fine. Am Di., 16. Aug. 2022 um 13:46 Uhr schrieb Daniel Gustafsson < dan...@yesql.se>: > > On 16 Aug 2022, at 12:54, Erik Rijkers wrote: > > > >

Re: Lower or Upper case for F.33. pg_trgm

2022-08-16 Thread Daniel Gustafsson
> On 16 Aug 2022, at 12:54, Erik Rijkers wrote: > > Op 16-08-2022 om 12:36 schreef Daniel Gustafsson: >>> On 16 Aug 2022, at 12:17, PG Doc comments form >>> wrote: >>> I have a question regarding the trigram algorithm and I can not find any >>> information about it in your documentation: >>

Re: Lower or Upper case for F.33. pg_trgm

2022-08-16 Thread Erik Rijkers
Op 16-08-2022 om 12:36 schreef Daniel Gustafsson: On 16 Aug 2022, at 12:17, PG Doc comments form wrote: I have a question regarding the trigram algorithm and I can not find any information about it in your documentation: Maybe we should add something about this? Yeah, it's a bit

Re: Lower or Upper case for F.33. pg_trgm

2022-08-16 Thread Daniel Gustafsson
> On 16 Aug 2022, at 12:17, PG Doc comments form wrote: > I have a question regarding the trigram algorithm and I can not find any > information about it in your documentation: Maybe we should add something about this? > Do you distinguish between lower and uppercase? Or do you consider all

Lower or Upper case for F.33. pg_trgm

2022-08-16 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/pgtrgm.html Description: Hey guys, I have a question regarding the trigram algorithm and I can not find any information about it in your documentation: Do you distinguish between lower