I forgot to say that the function is "position ( txtseach in txtcomplete)" :)
Bye El 22/04/2013, a las 19:36, Alfonso Afonso <aafon...@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. > > Bye for now and good luck :) > > El 22/04/2013, a las 18:12, Rafał Pietrak <ra...@zorro.isa-geek.com> escribió: > >>> 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 >> > > Alfonso Afonso > (personal) > > > > > Alfonso Afonso (personal)