sphinxsearch postgres sphinx_select disable match section

Question

I use sphinx for postgres and run this query

SELECT id,weight FROM sphinx_select('sessionsearchsphinxidx','someword','', '', 0,50000,'ranker=wordcount')

I want to use this method in case when no search query is defined. So in other words I want to return all records without any filter. Is it possible?

score 1 · Accepted Answer · answered May 05 '17 at 08:27

1

Have you tried leaving the query blank, the second param.

Of course the weight will be meaningless as no query to match but otherwise should work.

answered May 05 '17 at 08:27

barryhunter

It's strange but it doesn't work with blank param, it selects nothing – avalon May 05 '17 at 08:52
Have you checked the sphinx query log? Does the query get thought sphinx? – barryhunter May 07 '17 at 21:30

1 Answers1