On 31st of March 2017, Andrew Dunstan committed patch: Full Text Search support for json and jsonb The new functions are ts_headline() and to_tsvector. Dmitry Dolgov, edited and documented by me.

On 7th of April, Teodor Sigaev committed patch: Phrase full text search. Patch introduces new text search operator (< -> or ) into tsquery. On-disk and binary in/out format of tsquery are backward compatible. It has two side effect: - change order for tsquery, so, ...

On 11th of March, Teodor Sigaev committed patch: Tsvector editing functions Adds several tsvector editting function: convert tsvector to/from text array, set weight for given lexemes, delete lexeme(s), unnest, filter lexemes with given weights Author: Stas Kelvich with some editorization by me Reviewers: Tomas Vondram, Teodor ...

Today, I'd like to show you how you can use the same index for two different types of conditions. One that is using normal BTree indexing ( equal, less than, greater than ), and one that is using GIN/GiST index, ...

Before I'll start let me say that I am fan of what Oleg and Teodor did - their work is great, and I do appreciate their time and ideas. But - I simply don't like the idea of using FTS (Full ...

Today we have two interesting patches: patch by Teodor Sigaev and Oleg Bartunov, and committed by Tom Lane, which adds interesting capability to GIN indexes patch by Zoltan Boszormenyi, also committed by Tom, which adds "RESTART" option to ALTER SEQUENCE. With some ...

English disclaimer: this post will be in Polish only, as it's use for other nationalities is somehow limited :)