On 9/20/07, Andrew Dunstan <[EMAIL PROTECTED]> wrote:
> Can you retry both sets of tests but this time in C locale? The lower()
> code works differently in C locale, and it might be that we need to look
> at tweaking just one case.
Here we go with SQL_ASCII:
** 8.1 **
cityvox_c=# SELECT e.numeve FROM evenement e WHERE e.libgeseve LIKE
'%hocus pocus%';
numeve
--------
(0 rows)
Time: 117.485 ms
cityvox_c=# SELECT e.numeve FROM evenement e WHERE e.libgeseve ILIKE
'%hocus pocus%';
numeve
-----------
900024298
87578
(2 rows)
Time: 132.823 ms
** 8.2 **
cityvox_c=# SELECT e.numeve FROM evenement e WHERE e.libgeseve LIKE
'%hocus pocus%';
numeve
--------
(0 rows)
Time: 100.008 ms
cityvox_c=# SELECT e.numeve FROM evenement e WHERE e.libgeseve ILIKE
'%hocus pocus%';
numeve
-----------
900024298
87578
(2 rows)
Time: 113.579 ms
** 8.3 **
cityvox_c=# SELECT e.numeve FROM evenement e WHERE e.libgeseve LIKE
'%hocus pocus%';
numeve
--------
(0 rows)
Time: 112.462 ms
cityvox_c=# SELECT e.numeve FROM evenement e WHERE e.libgeseve ILIKE
'%hocus pocus%';
numeve
-----------
900024298
87578
(2 rows)
Time: 160.961 ms
--
Guillaume
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
