Add Support For Postgres Full Text Search tsvector Data Type

[anshap1719]

Closes #2705

Relates to #729

[anshap1719]

Hi @abonander, please approve the workflow run, it should now be fixed.

[anshap1719]

Hi @abonander, Did you get a chance to look at this again yet?

[abonander]

I review PRs as I get to them. SQLx is only a small part of my full-time job. Pinging me just fills up my notifications, it won't get your PR reviewed any faster.

[anshap1719]

@abonander I understand. Apologies for bothering you with those.

[abonander]

@anshap1719 can you please rebase and fix conflicts one last time? We're ready to merge this.

Note that the type mappings for the macros have moved to their corresponding database drivers: https://github.com/launchbadge/sqlx/blob/02c68a46c7c64b03b2a4eb7375041e0ca86d2fe5/sqlx-postgres/src/type_checking.rs#L10

[anshap1719]

Thanks @abonander, I have updated this PR.

[abonander]

Looks like cargo fmt needs to be run.

[anshap1719]

@abonander Right, my bad. Done now.

[anshap1719]

@wyhaya Thanks for the review. Will make the changes over the weekend and will also use all the cases you described as test cases.

[anshap1719]

@wyhaya Updated everything. Thanks for the code as well.

[anshap1719]

Hi @abonander Just FYI, this PR no longer covers tsquery. I removed it since I realized it's not ready and needs a lot of work, and the tsvector is already done and we want to avoid blocking that.

[KirDontsov]

Oh, guys sorry, but I really need tsvector support, can you check and merge it? @abonander

[abonander]

Closing due to inactivity. Feel free to reopen as a new PR, but please address my review comments.

[anshap1719]

@abonander I don't think I will. Thanks.