From: Bruce Momjian <bruce@momjian.us>
To: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>
Cc: PostgreSQL-documentation <pgsql-docs@postgresql.org>
Subject: Re: Most-common value docs in PG 12
Date: Thu, 26 Sep 2019 17:31:07 -0400
Message-ID: <20190926213107.GF16366@momjian.us> (raw)
In-Reply-To: <20190926210354.dcwq5frjs44gbvkz@development>
References: <20190926200522.GB16366@momjian.us>
<20190926201755.GA18930@alvherre.pgsql>
<20190926202059.GD16366@momjian.us>
<20190926210354.dcwq5frjs44gbvkz@development>
On Thu, Sep 26, 2019 at 11:03:54PM +0200, Tomas Vondra wrote:
> On Thu, Sep 26, 2019 at 04:20:59PM -0400, Bruce Momjian wrote:
> > Uh, people normally list things in defined order, so you would usually
> > not list them in non-defined order unless there is a purpose. Doing
> > that just to illustrate the order doesn't matter seems odd.
> >
>
> Well, that assumes there is a definition, and I don't think the zipcodes
> table is defined anywhere. So how do you know in what order are those
> columns defined?
In the USA, it is usually specific to general, i.e., city, state.
> Now, maybe the table should be defined somewhere in perform.sgml - I
> don't recall why exactly I chose not to do that, maybe because there is
> no universal definition (one country uses text, another number, ...)
Yeah, doesn't seem worth adding.
--
Bruce Momjian <bruce@momjian.us> http://momjian.us
EnterpriseDB http://enterprisedb.com
+ As you are, so once was I. As I am, so you will be. +
+ Ancient Roman grave inscription +
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: bruce@momjian.us, tomas.vondra@2ndquadrant.com, alvherre@2ndquadrant.com
Subject: Re: Most-common value docs in PG 12
In-Reply-To: <20190926213107.GF16366@momjian.us>
* 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