Full text search with $q=foo

[timwis]

I'm assuming the way to perform a free text search in standard SQL is using the function FREETEXT(). node-sqlparser does parse FREETEXT(foo, 'bar') but it does not parse FREETEXT(*, 'bar') (with the wildcard) which would be needed to support $q unless we knew the data model and could list each field.

[timothyclemansinsea]

The only references I'm finding for FREETEXT are for Microsoft SQL server. Since I'm interested in this parser for CartoDB I looked for full text search for Postgres and found http://www.postgresql.org/docs/9.1/static/textsearch-intro.html See http://stackoverflow.com/questions/36390439/full-text-search-with-postgres which has my failed attempt at this

[timothyclemansinsea]

select * FROM seattle_police_govqa_audit_trails as r WHERE regexp_replace(array_to_string(translate(string_to_array(r::text, ',')::text, '()', '')::text[], ' '), '[^a-zA-Z\s]', ' ', 'g')::tsvector @@ 'Dear & picked'::tsquery = true LIMIT 10