sphinx module: update, adding limit/max_results support
sphinx module: update, adding limit/max_results support

The updated version of the Sphinx module implements the ability to specify a
resultset length than the default 20, based on the libsphinxclient defaults.

To use this module we offer the following SQL functions;

create function sphinx_search(query string)
returns table (id bigint) external name sphinx."sphinx_search";

create function sphinx_searchIndex(query string, index string)
returns table (id bigint) external name sphinx."sphinx_searchIndex";


Introducing...

create function sphinx_searchIndexLimit(query string, idx string, lmt integer)
returns table (id bigint) external name sphinx."sphinx_searchIndexLimit";


Using it in your SQL;

select * from sphinx_searchIndexLimit('my query', '*', 20);


Reviewed-By: Fabian Groffen <644850cb8939d255ed752957b7c4458c52900f75@cwi.nl>

zyzyis/monetdb,zyzyis/monetdb,zyzyis/monetdb,zyzyis/monetdb,zyzyis/monetdb,zyzyis/monetdb,zyzyis/monetdb,zyzyis/monetdb,zyzyis/monetdb,zyzyis/monetdb