diff options
| author | Bruce Momjian | 2007-04-08 00:26:34 +0000 |
|---|---|---|
| committer | Bruce Momjian | 2007-04-08 00:26:34 +0000 |
| commit | e55c8e36ae44677dca4420bed07ad09d191fdf6c (patch) | |
| tree | a33cc231676436c724a361bfd4dd74d40713d79b /src/test | |
| parent | d7e2de6629e082322429726618e1dd75ea423cdc (diff) | |
Support syntax "CLUSTER table USING index", which is more logical.
Holger Schurig
Diffstat (limited to 'src/test')
| -rw-r--r-- | src/test/regress/expected/cluster.out | 2 | ||||
| -rw-r--r-- | src/test/regress/sql/cluster.sql | 2 |
2 files changed, 2 insertions, 2 deletions
diff --git a/src/test/regress/expected/cluster.out b/src/test/regress/expected/cluster.out index aa8e967269d..a9fca4d8fea 100644 --- a/src/test/regress/expected/cluster.out +++ b/src/test/regress/expected/cluster.out @@ -329,7 +329,7 @@ INSERT INTO clstr_3 VALUES (1); CLUSTER clstr_2; ERROR: there is no previously clustered index for table "clstr_2" CLUSTER clstr_1_pkey ON clstr_1; -CLUSTER clstr_2_pkey ON clstr_2; +CLUSTER clstr_2 USING clstr_2_pkey; SELECT * FROM clstr_1 UNION ALL SELECT * FROM clstr_2 UNION ALL SELECT * FROM clstr_3; diff --git a/src/test/regress/sql/cluster.sql b/src/test/regress/sql/cluster.sql index db300b19981..81a52c23dfa 100644 --- a/src/test/regress/sql/cluster.sql +++ b/src/test/regress/sql/cluster.sql @@ -122,7 +122,7 @@ INSERT INTO clstr_3 VALUES (1); CLUSTER clstr_2; CLUSTER clstr_1_pkey ON clstr_1; -CLUSTER clstr_2_pkey ON clstr_2; +CLUSTER clstr_2 USING clstr_2_pkey; SELECT * FROM clstr_1 UNION ALL SELECT * FROM clstr_2 UNION ALL SELECT * FROM clstr_3; |