Skip to content

Add PostgreSql TsQuery data type #5779

New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Merged
merged 5 commits into from
Jul 31, 2025

Conversation

griffio
Copy link
Collaborator

@griffio griffio commented Jun 3, 2025

Add TSQUERY data type to complement text vector searches https://www.postgresql.org/docs/current/datatype-textsearch.html#DATATYPE-TSQUERY

Fix function return types to use TSQUERY

Add Integration tests (functions, casts and match operator)


  • CHANGELOG.md's "Unreleased" section has been updated, if applicable.

@griffio griffio force-pushed the add-postgresql-tsquery branch 3 times, most recently from afc959f to 2c2a98b Compare June 10, 2025 08:14
@griffio griffio force-pushed the add-postgresql-tsquery branch from 2c2a98b to 5e7dac6 Compare June 12, 2025 14:26
griffio added 4 commits June 23, 2025 11:44
add TSQUERY data type
change function types to TSQUERY
add some functions
Explict typecast required as function returns REAL

Arguments are  TSVECTOR and TSQUERY

fix ts_rank
add plainto_tsquery
@griffio griffio force-pushed the add-postgresql-tsquery branch from 5e7dac6 to 4d7ab71 Compare June 23, 2025 10:44
@griffio griffio marked this pull request as ready for review June 25, 2025 15:49
@JakeWharton JakeWharton enabled auto-merge (squash) July 31, 2025 19:42
@JakeWharton JakeWharton merged commit c505097 into sqldelight:master Jul 31, 2025
18 checks passed
@griffio griffio deleted the add-postgresql-tsquery branch August 1, 2025 06:18
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Development

Successfully merging this pull request may close these issues.

2 participants