Re: [GENERAL] Limitation

[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@candle.pha.pa.us            |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026