postgresql & Fulltext & ranking & my own functions
Hello,
Documentation says : (
http://www.postgresql.org/docs/9.5/static/textsearch-controls.html#TEXTSEARCH-RANKING
)
"The built-in ranking functions are only examples. You can write your own
ranking functions and/or combine their results with additional factors to
fit your specific needs."
The build-in seems not enough for my use case. How to write my own ranking
functions ?
I would like to create something like ts_rank_cd( tsv, 'foo & bar', my_new_
normalization_integer)
----
pg 9.5
On Tue, May 3, 2016 at 3:21 PM, Nicolas Paris <niparisco@gmail.com> wrote:
Hello,
Documentation says : (
http://www.postgresql.org/docs/9.5/static/textsearch-controls.html#TEXTSEARCH-RANKING
)
"The built-in ranking functions are only examples. You can write your own
ranking functions and/or combine their results with additional factors to
fit your specific needs."The build-in seems not enough for my use case. How to write my own ranking
functions ?I would like to create something like ts_rank_cd( tsv, 'foo & bar',
my_new_normalization_integer)
you can look on src/backend/utils/adt/tsrank.c and write your own function.
google can help
https://www.google.ru/search?q=how+to+write+c+function+postgresql
Show quoted text
----
pg 9.5
Thanks Oleg, this is a good start for me
2016-05-03 15:47 GMT+02:00 Oleg Bartunov <obartunov@gmail.com>:
Show quoted text
On Tue, May 3, 2016 at 3:21 PM, Nicolas Paris <niparisco@gmail.com> wrote:
Hello,
Documentation says : (
http://www.postgresql.org/docs/9.5/static/textsearch-controls.html#TEXTSEARCH-RANKING
)
"The built-in ranking functions are only examples. You can write your own
ranking functions and/or combine their results with additional factors to
fit your specific needs."The build-in seems not enough for my use case. How to write my own
ranking functions ?I would like to create something like ts_rank_cd( tsv, 'foo & bar',
my_new_normalization_integer)you can look on src/backend/utils/adt/tsrank.c and write your own
function. google can help
https://www.google.ru/search?q=how+to+write+c+function+postgresql----
pg 9.5