ltree query not supported

[fyepi]

Describe the issue

ltree syntan path ~ '1.*' not supported

Vapor version

not used

Operating system and version

ubuntu 22.04

Swift version

6

Steps to reproduce

I have a table with a column path of type ltree.

This legitimate query in psql:

SELECT id, commented_by, path::text, create_date from comment where id = 1 OR ( path ~ '1.*' )::boolean order by id desc offset 0 limit 30;

is not supported by postges-nio.

Error is thrown:

[File: "bool.c", Severity: "ERROR", Routine: "boolin", Message: "invalid input syntax for type boolean: \"path ~ \'1.*\'\"", Line: "151", Localized Severity: "ERROR", Code: "22P02"]

Ltree support is pretty critical to us. If there a way to get ltree working?

Thanks

Outcome

No response

Additional notes

No response