From: Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
To: p.otoole@uwyo.edu
To: pgsql-docs@lists.postgresql.org
Subject: Re: Documentation of pg_index.indcollation missing some info in older versions?
Date: Sat, 7 Jul 2018 10:51:45 +0200
Message-ID: <1c3e6189-ef76-a5e1-5062-69f0957e05bc@2ndquadrant.com> (raw)
In-Reply-To: <152962053817.1255.17211424876113163924@wrigleys.postgresql.org>
References: <152962053817.1255.17211424876113163924@wrigleys.postgresql.org>
On 22.06.18 00:35, PG Doc comments form wrote:
> because 0::OID does not reference a valid pg_collation.oid.
>
> In the IRC, Zr40 helpfully pointed out that the latest documentation readily
> clarifies: "For each column in the index key, this contains the OID of the
> collation to use for the index, or zero if the column is not of a collatable
> data type."
It's a standard convention in the PostgreSQL system catalogs that OID
zero means "none". There are likely many places where this is not
explicitly documented.
--
Peter Eisentraut http://www.2ndQuadrant.com/
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: peter.eisentraut@2ndquadrant.com, p.otoole@uwyo.edu, pgsql-docs@lists.postgresql.org
Subject: Re: Documentation of pg_index.indcollation missing some info in older versions?
In-Reply-To: <1c3e6189-ef76-a5e1-5062-69f0957e05bc@2ndquadrant.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox