I forgot to say that the function is "position ( txtseach in txtcomplete)" :)
Bye
El 22/04/2013, a las 19:36, Alfonso Afonso <aafonsoc@gmail.com> escribió:
And using substring function? Do you have the same results?
I understand your arguments about normalization but, as you know, BNF is the best SQL Developer friend ;)
I used to avoid text fields and search/filter them (when it is possible), mainly because this consumption issues.... if the query has been on execution for more than 5 minutes, the virtual table that postgresql is preparing in memory should be huge.
About your question, if you are searching a text inside another text you could obtain bizarre results and consume a lot of resources, but my approximation to your problem