Date: Thu, 26 Sep 2019 17:31:07 -0400
From: Bruce Momjian <bruce@momjian.us>
To: Tomas Vondra <tomas.vondra@2ndquadrant.com>
Cc: Alvaro Herrera <alvherre@2ndquadrant.com>,
	PostgreSQL-documentation <pgsql-docs@postgresql.org>
Subject: Re: Most-common value docs in PG 12
Message-ID: <20190926213107.GF16366@momjian.us>
References: <20190926200522.GB16366@momjian.us>
 <20190926201755.GA18930@alvherre.pgsql>
 <20190926202059.GD16366@momjian.us>
 <20190926210354.dcwq5frjs44gbvkz@development>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
In-Reply-To: <20190926210354.dcwq5frjs44gbvkz@development>
User-Agent: Mutt/1.10.1 (2018-07-13)
Precedence: bulk

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 +