another locale problem

From: Daniel Kalchev <daniel(at)digsys(dot)bg>
To: pgsql-hackers(at)postgresql(dot)org
Subject: another locale problem
Date: 1999-06-10 14:17:25
Message-ID: 199906101417.RAA28085@dcave.digsys.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

While playing with --enable-locale and the like expressions I came across this
phenomenon ('somestring' is in cyrillic - last 64 codes from 0xa0 to 0xff)

SELECT key FROM t WHERE key ~* 'somestring'

returns the correct answers, properly matching upper/lower case characters -
this with --enable-locale, --with-mb=WIN and commenting out the USE_LOCALE
restrictions in gram.y. Explain shows Sequential scan, as expected...

However

SELECT key FROM t WHERE key ~* '^somestring'

returns no tuples and explain says it will use the index on key. Why is this?

If 'somestring' is ASCII characters, explain always gives sequential scan and
in both cases returns the proper results.

I am willing to do some testing if anyone has ideas how to patch the regex
code (I hate it :-).

Regards,
Daniel

Browse pgsql-hackers by date

  From Date Subject
Next Message Thomas Lockhart 1999-06-10 14:25:06 Re: [HACKERS] Foreign Keys
Previous Message Vadim Mikheev 1999-06-10 13:54:13 Re: Real Programmers (was: [HACKERS] Priorities for 6.6)