Thank you for the tsvectors info!
-wes
On Wed, Jul 13, 2011 at 12:11 AM, Kevin Crain wrote:
> You can do full-text search in postgres now using ts_vectors. I'd
> recommend going that route. Doing like comparisons is not a good idea
> if you don't know the first part of the string you are searc
You can do full-text search in postgres now using ts_vectors. I'd
recommend going that route. Doing like comparisons is not a good idea
if you don't know the first part of the string you are searching
forIt appears to be much faster from my experience to search for
ab% than it is to search fo
I'm using Erlang and postgresql to build a web interface. When I
create the query string I get something like:
select * from table where field::text ilike '%%'
But when I do that (if someone types in '\' for part of the text
search), I get a pg log entry to use E'\\'
How would I use E'' wit
