From: | Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us> |
---|---|
To: | John Huttley <john(at)mwk(dot)co(dot)nz> |
Cc: | pgsql-general <pgsql-general(at)postgreSQL(dot)org> |
Subject: | Re: [GENERAL] Limitation |
Date: | 1999-06-24 22:56:10 |
Message-ID: | 199906242256.SAA28508@candle.pha.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
[Charset iso-8859-1 unsupported, filtering to ASCII...]
> The answer is that you are thinking as indexes in the context of fast lookup
> on fields.
>
> However my requirement comes from a need to ensure that every single field
> in the
> table forms a unique combination. (not my design, I might add)
Ooow, that is a good point. Unique requires a unique index.
>
> Now you know why, can you append it to the TODO list?
Can I get someone else to agree it should be added?
>
> On thinking about it, I wonder if the same field can appear more than
> once in an index. Now that would be weird!
I bet it can.
--
Bruce Momjian | http://www.op.net/~candle
maillist(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026
From | Date | Subject | |
---|---|---|---|
Next Message | John Huttley | 1999-06-24 23:48:11 | Re: [GENERAL] Limitation |
Previous Message | Dustin Sallings | 1999-06-24 22:54:49 | Re: [GENERAL] Limitation |