Fulltext Search Function

Started by Jeremaine Johnsonalmost 14 years ago1 messagesgeneral
Jump to latest
#1Jeremaine Johnson
JJohnson@vocal.co.uk

Hi,

I have a full text search query (below) which works fine but would like to write a function which will make use of this query passing in two parameters, any ideas please?

SELECT name, description, ts_rank_cd(textsearchable_index_col, query, 32 /* rank/(rank+1) */) AS rank

FROM companies , to_tsquery('client | (uk & vocal)') query

WHERE query @@ textsearchable_index_col

ORDER BY rank DESC

LIMIT 10;

I look forward to hearing from you.

Regards,

Jeremaine Johnson
DBA / Developer