Gregory Stark wrote: > > But that won't help in the example you posted upthread, because > > char(N) is not fixed-length. > > Sure it is because any sane database--certainly any sane database > using char(N)--is in C locale anyways.
This matter is completely independent of the choice of locale and therefore any unilateral redefinition of sanity that you might come up with. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---------------------------(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
