Postgres Pro
Downloads
Home   >   mailing lists

Thread: "collation" or "collation oder"

"collation" or "collation oder"

From
Tatsuo Ishii
Date:
Currently in the docs both "collation" and "collation order" are
used. I think this is confusing because IMO "collation" implies
"order", and "collation order" is redundant.

Can we change "collation order" to "collation"? git grep shows
followings:

amcheck.sgml:     collation order between a primary server and a standby server is
charset.sgml:      locale-specific collation order, number formatting, translated
charset.sgml:    settings can modify the collation order to suit a variety of needs. For
ref/create_database.sgml:        Sets the default collation order and character classification in the
ref/create_database.sgml:        <literal>libc</literal>, also sets the default collation order to use
ref/create_database.sgml:        collation order and character classification, overriding the setting
ref/create_database.sgml:        collation order and character classification, overriding the setting

Best reagards,
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp

Re: "collation" or "collation oder"

From
Peter Eisentraut
Date:
On 14.12.24 03:32, Tatsuo Ishii wrote:
> Currently in the docs both "collation" and "collation order" are
> used. I think this is confusing because IMO "collation" implies
> "order", and "collation order" is redundant.

I think there is a difference.  A collation is a database object, a 
collation order is the order produced when invoking that collation.  For 
example, in amcheck.sgml:

"""
... an inconsistency in the collation order between a primary server and 
a standby server ...
"""

If we wrote just "collation" here I think it would be less clear, 
because what's the problem is whether the order is different, not 
whether the collation objects are different.

Re: "collation" or "collation oder"

From
Tatsuo Ishii
Date:
> I think there is a difference.  A collation is a database object, a
> collation order is the order produced when invoking that collation.
> For example, in amcheck.sgml:
> 
> """
> ... an inconsistency in the collation order between a primary server
> and a standby server ...
> """
> 
> If we wrote just "collation" here I think it would be less clear,
> because what's the problem is whether the order is different, not
> whether the collation objects are different.

That makes sense. Thanks for the explanation.
--
Tatsuo Ishii
SRA OSS K.K.
English: http://www.sraoss.co.jp/index_en/
Japanese:http://www.sraoss.co.jp