| From: | "Dot Yet" <dot(dot)yet(at)gmail(dot)com> |
|---|---|
| To: | "General PostgreSQL List" <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: Unique indicies |
| Date: | 2008-02-22 21:33:04 |
| Message-ID: | 93bc4af40802221333nc541d6dk87ee47254d649852@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
oops.... yeah... must have read it clearly
rgds,
dotyet
On 2/22/08, Erik Jones <erik(at)myemma(dot)com> wrote:
>
>
> On Feb 22, 2008, at 8:38 AM, Dot Yet wrote:
>
> > that would mean
> >
> > Every row in foo for column f1 has to be unique
> > and
> > Every row in foo for column f2 has to be unique
>
> The OP was asking about maintaining normal indexes on each in
> addition to the unique index on (f1, f2), not separate unique indexes.
>
> Erik Jones
>
> DBA | Emma(R)
> erik(at)myemma(dot)com
> 800.595.4401 or 615.292.5888
> 615.292.0777 (fax)
>
> Emma helps organizations everywhere communicate & market in style.
> Visit us online at http://www.myemma.com
>
>
>
>
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Kynn Jones | 2008-02-22 21:49:10 | PostgreSQL's hashing function? |
| Previous Message | Kris Jurka | 2008-02-22 21:15:42 | Re: Understanding ps -ef "command" column |