Skip site navigation (1) Skip section navigation (2)

pgsql: Second pass at improving LIKE/regex estimation in non-C locales.

From: tgl(at)postgresql(dot)org (Tom Lane)
To: pgsql-committers(at)postgresql(dot)org
Subject: pgsql: Second pass at improving LIKE/regex estimation in non-C locales.
Date: 2007-11-09 20:10:20
Message-ID: 20071109201020.EB2A77540F0@cvs.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-committers
Log Message:
-----------
Second pass at improving LIKE/regex estimation in non-C locales.  It turns
out that it's actually quite likely that a string that is an extension of
the given prefix will sort as larger than the "greater" string our previous
code created.  To provide some defense against that, do the comparisons
against a modified string instead of just the bare prefix.  We tack on
"Z", "z", "y", or "9", whichever is seen as largest in the current locale.
Testing suggests that this is sufficient at least for cases involving
ASCII data.

Tags:
----
REL8_1_STABLE

Modified Files:
--------------
    pgsql/src/backend/utils/adt:
        selfuncs.c (r1.191.2.4 -> r1.191.2.5)
        (http://developer.postgresql.org/cvsweb.cgi/pgsql/src/backend/utils/adt/selfuncs.c?r1=1.191.2.4&r2=1.191.2.5)

pgsql-committers by date

Next:From: Alvaro HerreraDate: 2007-11-09 22:22:46
Subject: pgsql: Point to our own UUID page instead of to Wikipedia.
Previous:From: Tom LaneDate: 2007-11-09 20:10:09
Subject: pgsql: Second pass at improving LIKE/regex estimation in non-C locales.

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group