Hello,

We're currently not going to support all of these vendor-specific functions
in the jOOQ API. However, you can easily add support for them yourself
using jOOQ's "plain SQL" API:
http://www.jooq.org/doc/latest/manual/sql-building/plain-sql

An example:

public static Field<String> trimLeading(String leading, String from) {
    return DSL.field("trim(leading {0} from {1})", String.class,
DSL.val(leading), DSL.val(from));
}


Hope this helps,
Lukas

2015-06-08 10:19 GMT+02:00 Martin Rumánek <[email protected]>:

> I would like use DSL for query like  "SELECT trim(leading 'prefix' from
> 'prefixThomas')"
>
>
> Is it planned to add support for modifiers such as leading | trail | both?
> (http://www.postgresql.org/docs/9.1/static/functions-string.html)
>
> --
> 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/d/optout.
>

-- 
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/d/optout.

Reply via email to