Tom Lane wrote: > Martijn van Oosterhout <kleptog@svana.org> writes: >> The fact is that if you're using binary format paramaters and output >> you can put embedded nulls into strings and get them back out. > > Not any more ;-) >
OK, but now that this "feature" has been removed in 8.1.4, how is this supposed to be handled, given that we don't control what string data we're handed? How does psql deal with it? >> By changing a >> few strcmps to memcmps you can get sane behaviour for sorting a several >> other operations. > > Given the lack of "memcoll", that proposal isn't going to fly ... > at least not until we replace all the locale support code with something > else (that hopefully will be null-clean). > > regards, tom lane Thanks, Eric ---------------------------(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