Hello,
PostgreSQL has quite a few of these interesting functions / data types /
operators, that are not natively supported by jOOQ. As always, if something
is not natively supported, your best choice is to resort to plain SQL:
http://www.jooq.org/doc/3.2/manual/sql-building/plain-sql/
E.g. your conditional expression would probably best be written as such.
DSL.condition("{0} @@ {1}::tsquery", field,
DSL.val("match1|match2|match3:*"));
If you're planning on doing a lot of these text queries, you might make the
above broadly available to your application through a reusable API.
In the long run, it might make sense to implement such support in jOOQ,
though:
https://github.com/jOOQ/jOOQ/issues/2938
Cheers
Lukas
2014/1/8 Harshith <[email protected]>
>
>
> Does Jooq support postgres text/document search functionality using
> tsquery? If so, is there an example that I can look up? I couldn't find
> anything in the manual or web search.
>
> If not, what would be a suggested alternative to a query that uses
> textsearch. For example what would be the easiest way to translate a
> conditional like:
>
> field @@ 'match1|match2|match3:*'::tsquery
>
> --
> You received this message because you are subscribed to the Google Groups
> "jOOQ User Group" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected].
> For more options, visit https://groups.google.com/groups/opt_out.
>
--
You received this message because you are subscribed to the Google Groups "jOOQ
User Group" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/groups/opt_out.
