Re: [PATCH] add CLUSTER table ORDER BY index

"Holger Schurig" <holgerschurig(at)gmx(dot)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