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
On Sat, Apr 23, 2005 at 08:45:25AM -0700, Joshua D. Drake wrote:
> 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
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 in
- Original Message -
From: "Craig Bryden" <[EMAIL PROTECTED]>
To: "pgsql"
Sent: Saturday, April 23, 2005 5:45 AM
Subject: [GENERAL] PRIMARY KEY and indexes
Hi
I come from a MS-SQL background and I'm trying to get some clarity on
indexes in Postgr
Hi
I come from a MS-SQL background and I'm trying to get some clarity on
indexes in Postgres. If anyone can help with the following questions it
would be much appreciated:
1. When creating a primary key contraint on a table, is an equivalent index
automatically created for you, or would I have to
