diff options
| author | Tom Lane <tgl@sss.pgh.pa.us> | 2001-06-02 19:01:53 +0000 | 
|---|---|---|
| committer | Tom Lane <tgl@sss.pgh.pa.us> | 2001-06-02 19:01:53 +0000 | 
| commit | 5433b4838006ffa4da80e5cdf64452bccd2aabdc (patch) | |
| tree | ab4fde04d0614904ea39ef31fb73e9f468de175b /src/include/optimizer/paths.h | |
| parent | e54203646176167271dc50a7b8f7bbe0d3ea6e75 (diff) | |
Tweak sorting so that nulls appear at the front of a descending sort
(vs. at the end of a normal sort).  This ensures that explicit sorts
yield the same ordering as a btree index scan.  To be really sure that
that equivalence holds, we use the btree entries in pg_amop to decide
whether we are looking at a '<' or '>' operator.  For a sort operator
that has no btree association, we put the nulls at the front if the
operator is named '>' ... pretty grotty, but it does the right thing in
simple ASC and DESC cases, and at least there's no possibility of getting
a different answer depending on the plan type chosen.
Diffstat (limited to 'src/include/optimizer/paths.h')
0 files changed, 0 insertions, 0 deletions
