Tom Lane wrote:
> Gregory Stark <[EMAIL PROTECTED]> writes:
> > The key to the algorithm is that it uses a trie to bin rows with common
> > leading prefixes together. This avoids performing redundant comparisons
> > between those columns later.
>
> Interesting, but doesn't that make it utterly useless for sorting in
> non-C locales?
It seems so. But on the other hand it might prove helpful for
multicolumn sorts (which removes the "datatype-specific" objection).
--
Alvaro Herrera Valdivia, Chile ICBM: S 39º 49' 18.1", W 73º 13' 56.4"
"No hay cielo posible sin hundir nuestras raíces
en la profundidad de la tierra" (Malucha Pinto)
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
