Skip site navigation (1) Skip section navigation (2)

Re: [PATCH] add CLUSTER table ORDER BY index

From: Gregory Stark <stark(at)enterprisedb(dot)com>
To: "Holger Schurig" <holgerschurig(at)gmx(dot)de>
Cc: <pgsql-patches(at)postgresql(dot)org>
Subject: Re: [PATCH] add CLUSTER table ORDER BY index
Date: 2007-03-27 21:40:13
Message-ID: 87k5x2xt4y.fsf@oxford.xeocode.com (view raw or flat)
Thread:
Lists: pgsql-patches
"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


In response to

Responses

pgsql-patches by date

Next:From: Alvaro HerreraDate: 2007-03-27 21:41:22
Subject: autovacuum: multiple workers
Previous:From: Simon RiggsDate: 2007-03-27 21:07:49
Subject: Re: Full page writes improvement, code update

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group