Add support for tsvector and tsquery

[acaprari]

Please add support for tsvector and tsquery PG types.

A use case for them would be allowing for a custom full text parser written at application level whose results are directly applied in queries, without using to_tsvector() and to_tsquery() functions.

Also, a BinaryEncoder implementation for tsvector would allow direct insertions of tsvectors via COPY FROM.

[ksankeerth]

Hi @jackc,
I'd like to work on this issue. Can I give a try? thanks

[jackc]

@ksankeerth You're welcome to it. But pgx v5 should be released within the next month and it has significant changes to the type system. You might want to build it directly there to save the porting work from v4 to v5.

[ZhouXing19]

Hello, any update on this? Thanks!

[rohan-joshi]

any further updates on this?