Re: PRIMARY KEY and indexes

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Alvaro Herrera <alvherre(at)dcc(dot)uchile(dot)cl>
Cc: Craig Bryden <postgresql(at)bryden(dot)co(dot)za>, pgsql <pgsql-general(at)postgresql(dot)org>
Subject: Re: PRIMARY KEY and indexes
Date: 2005-04-23 15:45:25
Message-ID: 426A6D95.7080104@commandprompt.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Alvaro Herrera wrote:
> On Sat, Apr 23, 2005 at 11:45:43AM +0200, Craig Bryden wrote:
>
>
>>2. How do I create a clustered index in postgres?
>
>
> There is no such thing as a clustered index in Postgres. You can order
> the table itself following an index (that's what CLUSTER does), but you
> don't get the data itself inside the index, which is what AFAIK a
> clustered index in other database systems.

I believe this is being worked on for 8.1 yes?

Sincerely,

Joshua D. Drake
Command Prompt, Inc.

>

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2005-04-23 15:47:26 Re: Playing with PostgreSQL and Access VBA
Previous Message Joshua D. Drake 2005-04-23 15:37:02 Re: Pgpool questions