Hi Jeff,
Unicode case folding would be great!
I wonder if there might still be situations where multiple collations
are applied within the same expression/statement and this produces a
surprising result. So far I'm mostly coming up with examples that seem
more contrived or less surprising, but ma
Hi there,
I mentioned to Jeremy at pgConf.dev that using non-default collations
in some SQL idioms can produce undesired results, and he asked me to
send an email. An example idiom is the way Django implements
case-insensitive comparisons using "upper(x) = upper(y)" [1][2][3] ,
which returns false
rable.
Thanks Bruce for applying my more trivial patches. :-)
From d31521a344e4906067f686b3611048f87f32215a Mon Sep 17 00:00:00 2001
From: Will Mortensen
Date: Wed, 1 Jun 2022 23:14:19 -0700
Subject: [PATCH 1/4] doc: clarify example of serialization anomaly
This example has been pointed o
Not sure if these would be considered redundant, since they don't add
any new information, but I think I would have found them helpful as a
reader.
From ec76436429bd7d1e3dddc0b26ba9b1539499f40b Mon Sep 17 00:00:00 2001
From: Will Mortensen
Date: Sat, 27 Aug 2022 17:31:13 -0700
Subject: [PATC
could be removed in favor of a reference
to the Serializable section and its example.
From 13007ea36fa44bd80e595fb89deddfb6184e96d1 Mon Sep 17 00:00:00 2001
From: Will Mortensen
Date: Wed, 1 Jun 2022 23:14:19 -0700
Subject: [PATCH 4/6] doc: clarify example of serialization anomaly
This example has
This doesn't add any new information, but perhaps eases the reader
into this long section. It also gives the discussion of plain SELECT
its own paragraph, better paralleling the subsequent paragraphs.
From b02c18896e4590eff6b396cd0faedac62b29bf68 Mon Sep 17 00:00:00 2001
From: Will Mortensen
Fix markup indentation and add a mention of MERGE.
From 46977fbe5fa0a26ef77938a8fe30b9def062e8f8 Mon Sep 17 00:00:00 2001
From: Will Mortensen
Date: Sat, 27 Aug 2022 17:07:11 -0700
Subject: [PATCH 1/6] doc: fix markup indentation in MVCC
---
doc/src/sgml/mvcc.sgml | 16
1 file
