[GENERAL] indexed regex select optimisation missing?

m not holding my breath fort a quick resolution from myself, any ideas? -- ---- Stuart Woolford, [EMAIL PROTECTED] Unix Consultant. Software Developer. Supra Club of New Zealand.

Re: [GENERAL] indexed regex select optimisation missing?

bout the slow queries that say indexes are used for this type of search. using the >= AND < trick does seem to work, but is a little non-obvious (and hard to code in some situations, it will make quite a difference to how I need to implement my searching system) > > Ross thank you very very much for your assistance on this, it is greatly appreciated! -- Stuart Woolford, [EMAIL PROTECTED] Unix Consultant. Software Developer. Supra Club of New Zealand.

Re: [GENERAL] indexed regex select optimisation missing?

missing or broken) would make postgresql a much more powerful tool for this job for what would seem to be a quite simple addition. > > However, > > 4. Hash index is never used makes a lot off sense, hash indexes do not supply ordering information, and are therefore only usefull

Re: [GENERAL] indexed regex select optimisation missing?

afe option everywhere (but thinking about it, character order is locale specific, so maybe it's not.. I'll look, if this is the case, enable-locale is a VERY important option for text searching, perhaps should be added the the section 4.x in the FAQ where the regex optimisation is mentioned