Re: Is a better way to have the same result of this

From: Tomasz Myrta <jasiek(at)klaster(dot)net>
To: vernonw(at)gatewaytech(dot)com
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: Is a better way to have the same result of this
Date: 2002-12-05 21:19:58
Message-ID: 3DEFC2FE.2070702@klaster.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Vernon Wu wrote:

> Tomasz,
>
> I am under the impression that a primary key field is automically as a
> unique index. It seems to be correct after I verify it
> with the page
> http://www.commandprompt.com/ppbook/index.lxp?lxpwrap=c13329%2ehtm#CREATINGANINDEX

You are right. Primary key creates unique index. I use sometimes Pgadmin
and it doesn't show these indexes :-(
Tomasz Myrta

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Vernon Wu 2002-12-05 21:23:16 Re: Is a better way to have the same result of this query?
Previous Message Jochem van Dieten 2002-12-05 21:06:03 Re: Is a better way to have the same result of this query?