I am adding this to the TODO list.
--
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
Hi all,
I could create a 9-key index.
create table ix9 (
i1 int4,
i2 int4,
i3 int4,
i4 int4,
i5 int4,
i6 int4,
i7 int4,
i8 int4,
i9 int4,
primary key (i1,i2,i3,i4,i5,i6,i7,i8,i9)
);
NOTICE: CREATE TABLE/PRIMARY KEY will create implicit index 'ix9_pkey'
for table 'ix9'
CREATE
\d ix9_pkey
Table = ix9_pkey
+----------------------------------+----------------------------------+-----
--+
| Field | Type |
Length|
+----------------------------------+----------------------------------+-----
--+
| i1 | int4 |
4 |
| i2 | int4 |
4 |
| i3 | int4 |
4 |
| i4 | int4 |
4 |
| i5 | int4 |
4 |
| i6 | int4 |
4 |
| i7 | int4 |
4 |
| i8 | int4 |
4 |
| i9 | int4 |
4 |
+----------------------------------+----------------------------------+-----
--+
Is it right ?
Regards.
Hiroshi Inoue
Inoue@tpf.co.jp