Обсуждение: 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."
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
----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>:
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