diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2005-04-11 23:06:57 +0000 |
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2005-04-11 23:06:57 +0000 |
| commit | addc42c339208d6a7a1d652fbf388e8aea7f80b9 (patch) | |
| tree | e349d31f2ae1006ed4078b811dae8d842e00d969 /src/test/regress/sql/create_index.sql | |
| parent | c3294f1cbfe02293b4a7c6b2e58ca4c09a7e541f (diff) | |
| download | postgresql-addc42c339208d6a7a1d652fbf388e8aea7f80b9.tar.gz | |
Create the planner mechanism for optimizing simple MIN and MAX queries
into indexscans on matching indexes. For the moment, it only handles
int4 and text datatypes; next step is to add a column to pg_aggregate
so that all MIN/MAX aggregates can be handled. Per my recent proposal.
Diffstat (limited to 'src/test/regress/sql/create_index.sql')
| -rw-r--r-- | src/test/regress/sql/create_index.sql | 2 |
1 files changed, 2 insertions, 0 deletions
diff --git a/src/test/regress/sql/create_index.sql b/src/test/regress/sql/create_index.sql index 6fa0b91e83..71c0b0c2b0 100644 --- a/src/test/regress/sql/create_index.sql +++ b/src/test/regress/sql/create_index.sql @@ -20,6 +20,8 @@ CREATE INDEX tenk1_unique2 ON tenk1 USING btree(unique2 int4_ops); CREATE INDEX tenk1_hundred ON tenk1 USING btree(hundred int4_ops); +CREATE INDEX tenk1_thous_tenthous ON tenk1 (thousand, tenthous); + CREATE INDEX tenk2_unique1 ON tenk2 USING btree(unique1 int4_ops); CREATE INDEX tenk2_unique2 ON tenk2 USING btree(unique2 int4_ops); |