Running lquery against an ltree column

[Jason Bennett]

Appreciate all of the help you provide, Lucas.

I have an Ltree column, which I've generated using the extension jar, so it's a proper Ltree type in jOOQ. I would like to run an lquery against this column, but jOOQ doesn't seem to have that support. Do I need to write raw SQL here to use the `~` or `@>` operators?

[Lukas Eder]

Yes

On Tue, Feb 27, 2024 at 1:33 AM Jason Bennett <jas...@gmail.com> wrote:

Appreciate all of the help you provide, Lucas.

I have an Ltree column, which I've generated using the extension jar, so it's a proper Ltree type in jOOQ. I would like to run an lquery against this column, but jOOQ doesn't seem to have that support. Do I need to write raw SQL here to use the `~` or `@>` operators?

--
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 jooq-user+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jooq-user/1613d694-05ee-49b8-b7c2-d60e04860b04n%40googlegroups.com.