Pg-sphinx is an extension for PostgreSQL which allows to integrate Sphinx search engine.
makesudo make installSuperuser is required.
echo 'CREATE EXTENSION sphinx;' | psql -U postgres mydatabasesudo make uninstallsphinx_select(
/*index*/ varchar,
/*query*/ varchar,
/*condition*/ varchar,
/*order*/ varchar,
/*offset*/ int,
/*limit*/ int,
/*options*/ varchar)Returns pairs (id, weight).
sphinx_replace(
/*index*/ varchar,
/*id*/ int,
/*data*/ varchar[])Updates document with specified id. Data array must have following format: ARRAY[‘key1’, ‘value2’, …]
sphinx_delete(
/*index*/ varchar,
/*id*/ int)Removes specified document.
sphinx_snippet(
/*index*/ varchar,
/*query*/ varchar,
/*data*/ varchar,
/*before*/ varchar,
/*after*/ varchar)Returns snippets for a given data and search query.
Example:
SELECT sphinx_snippet('blog_posts', 'photo', 'There are photos from monday meeting', '<b>', '</b>')This query will return following text:
'There are <b>photos</b> from monday meeting'