search

jackc / pgtype

MIT License
314 stars 112 forks source link

Add support for tsvector and tsquery #126

Open acaprari opened 3 years ago

acaprari commented 3 years ago

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 commented 2 years ago

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

jackc commented 2 years ago

@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 commented 5 months ago

Hello, any update on this? Thanks!