Re: Most-common value docs in PG 12

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 +