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


Wed, 14 Jul 1999 11:25:09 +0900
"Hiroshi Inoue" <Inoue@tpf.co.jp>
9-key index ?