Re: [GENERAL] Safe usage of tsearch2: to_tsquery('')

2007-08-05 Thread cluster
Isn't plainto_tsquery() what you're looking for? Yes if plainto_tsquery() is safe enough for inputting user search keywords it looks like it is. I didn't knew it existed. Thanks ---(end of broadcast)--- TIP 5: don't forget to increase your free

Re: [GENERAL] Safe usage of tsearch2: to_tsquery('')

2007-08-04 Thread Tom Lane
cluster <[EMAIL PROTECTED]> writes: > In a web application I would like to use tsearch2 to search for by-user > entered key words. That is, the user provides the keywords in a space > separated list in some input text field. For that I use > to_tsquery('') but I would like to do this in a safe w

[GENERAL] Safe usage of tsearch2: to_tsquery('')

2007-08-04 Thread cluster
In a web application I would like to use tsearch2 to search for by-user entered key words. That is, the user provides the keywords in a space separated list in some input text field. For that I use to_tsquery('') but I would like to do this in a safe way so that the user cannot misuse to_tsquer