- Aug 21, 1999
-
-
Tom Lane authored
sort order down into planner, instead of handling it only at the very top level of the planner. This fixes many things. An explicit sort is now avoided if there is a cheaper alternative (typically an indexscan) not only for ORDER BY, but also for the internal sort of GROUP BY. It works even when there is no other reason (such as a WHERE condition) to consider the indexscan. It works for indexes on functions. It works for indexes on functions, backwards. It's just so cool... CAUTION: I have changed the representation of SortClause nodes, therefore THIS UPDATE BREAKS STORED RULES. You will need to initdb.
-
- Jul 19, 1999
-
-
Tom Lane authored
of the SELECT part of the statement is just like a plain SELECT. All INSERT-specific processing happens after the SELECT parsing is done. This eliminates many problems, e.g. INSERT ... SELECT ... GROUP BY using the wrong column labels. Ensure that DEFAULT clauses are coerced to the target column type, whether or not stored clause produces the right type. Substantial cleanup of parser's array support.
-
- Jul 16, 1999
-
-
Bruce Momjian authored
-
- Jul 15, 1999
-
-
Bruce Momjian authored
-
- May 26, 1999
-
-
Bruce Momjian authored
-
- Feb 23, 1999
-
-
Thomas G. Lockhart authored
-
- Sep 01, 1998
-
-
Bruce Momjian authored
-
- Feb 26, 1998
-
-
Bruce Momjian authored
-
- Dec 29, 1997
-
-
Bruce Momjian authored
-
Bruce Momjian authored
-
- Nov 26, 1997
-
-
Bruce Momjian authored
-
Bruce Momjian authored
-
- Nov 25, 1997
-
-
Bruce Momjian authored
-