"Holger Schurig" <[EMAIL PROTECTED]> 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 ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend