Skip to content

Commit 83843a4

Browse files
bmomjianbmomjian
committed
Update:
> * Allow the creation of indexes with mixed ascending/descending > specifiers > > This is possible now by creating an operator class with reversed sort > operators. One complexity is that NULLs would then appear at the start > of the result set, and this might affect certain sort types, like > merge join. >
1 parent 898eb25 commit 83843a4

File tree

2 files changed

+17
-4
lines changed

2 files changed

+17
-4
lines changed

‎doc/TODO

Lines changed: 9 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -2,7 +2,7 @@
22
PostgreSQL TODO List
33
====================
44
Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us)
5-
Last updated: Mon Mar 6 17:51:00 EST 2006
5+
Last updated: Sat Apr 8 23:26:57 EDT 2006
66

77
The most recent version of this document can be viewed at
88
http://www.postgresql.org/docs/faqs.TODO.html.
@@ -827,7 +827,14 @@ Indexes
827827
* Allow accurate statistics to be collected on indexes with more than
828828
one column or expression indexes, perhaps using per-index statistics
829829
* Add fillfactor to control reserved free space during index creation
830-
* Allow the creation of indexes with mixed ascending/descending specifiers
830+
* Allow the creation of indexes with mixed ascending/descending
831+
specifiers
832+
833+
This is possible now by creating an operator class with reversed sort
834+
operators. One complexity is that NULLs would then appear at the start
835+
of the result set, and this might affect certain sort types, like
836+
merge join.
837+
831838
* Allow constraint_exclusion to work for UNIONs like it does for
832839
inheritance, allow it to work for UPDATE and DELETE statements, and allow
833840
it to be used for all statements with little performance impact

‎doc/src/FAQ/TODO.html

Lines changed: 8 additions & 2 deletions
Original file line numberDiff line numberDiff line change
@@ -8,7 +8,7 @@
88
<body bgcolor="#FFFFFF" text="#000000" link="#FF0000" vlink="#A00000" alink="#0000FF">
99
<h1><a name="section_1">PostgreSQL TODO List</a></h1>
1010
<p>Current maintainer: Bruce Momjian (<a href="mailto:pgman@candle.pha.pa.us">pgman@candle.pha.pa.us</a>)<br/>
11-
Last updated: Mon Mar 6 17:51:00 EST 2006
11+
Last updated: Sat Apr 8 23:26:57 EDT 2006
1212
</p>
1313
<p>The most recent version of this document can be viewed at<br/>
1414
<a href="http://www.postgresql.org/docs/faqs.TODO.html">http://www.postgresql.org/docs/faqs.TODO.html</a>.
@@ -752,7 +752,13 @@ <h1><a name="section_13">Indexes</a></h1>
752752
</li><li>Allow accurate statistics to be collected on indexes with more than
753753
one column or expression indexes, perhaps using per-index statistics
754754
</li><li>Add fillfactor to control reserved free space during index creation
755-
</li><li>Allow the creation of indexes with mixed ascending/descending specifiers
755+
</li><li>Allow the creation of indexes with mixed ascending/descending
756+
specifiers
757+
<p> This is possible now by creating an operator class with reversed sort
758+
operators. One complexity is that NULLs would then appear at the start
759+
of the result set, and this might affect certain sort types, like
760+
merge join.
761+
</p>
756762
</li><li>Allow constraint_exclusion to work for UNIONs like it does for
757763
inheritance, allow it to work for UPDATE and DELETE statements, and allow
758764
it to be used for all statements with little performance impact

0 commit comments

Comments
 (0)