Re: [PATCH] add CLUSTER table ORDER BY index - Mailing list pgsql-patches

From Gregory Stark
Subject Re: [PATCH] add CLUSTER table ORDER BY index
Date
Msg-id 87k5x2xt4y.fsf@oxford.xeocode.com
Whole thread Raw
In response to [PATCH] add CLUSTER table ORDER BY index  (Holger Schurig <holgerschurig@gmx.de>)
Responses Re: [PATCH] add CLUSTER table ORDER BY index
List pgsql-patches
"Holger Schurig" <holgerschurig@gmx.de> writes:

> * psql tab-completion, it favours now CLUSTER table ORDER BY index"

It occurs to me (sorry that I didn't think of this earlier) that if we're
going to use "ORDER BY" it really ought to take a list columns. It would be
more consistent with what ORDER BY means in queries and one day we may want to
add support for ordering by arbitrary lists of columns even if no index
exists.

It may be reasonable to allow both to coexist and just have an arbitrary rule
that if an index of the specified name exists takes precedence over any
columns. I've never seen anyone name their indexes in a way that would
conflict with a column anyways.

--
  Gregory Stark
  EnterpriseDB          http://www.enterprisedb.com


pgsql-patches by date:

Previous
From: "Simon Riggs"
Date:
Subject: Re: [HACKERS] Full page writes improvement, code update
Next
From: Alvaro Herrera
Date:
Subject: autovacuum: multiple workers