implementing overlap array function - postgres 9.5

[Leandro Aguilar]

Hi to all, how can I implement the following function with jooq 3.8.1 ?
tags column is an array of strings.

SELECT
  *
FROM
  public.objects
  where   tags && '{tag5,tag3}'::varchar[] ;

[Lukas Eder]

Hi Leandro,

You can use jOOQ's "plain SQL" capabilities to create your own predicates:

http://www.jooq.org/doc/latest/manual/sql-building/plain-sql

In your case:

public static <T> void Condition arrayOverlaps(Field<T[]> left, Field<T[]> right) {

    return DSL.condition("{0} && {1}", left, right);

}

And call it as such:

arrayOverlaps(OBJECTS.TAGS, DSL.val(new String[] { "tag5", "tag3" }));

Hope this helps,

Lukas

--
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.
For more options, visit https://groups.google.com/d/optout.

[lehp...@gmail.com]

Hi,

Are there plans to add native support for this in jOOQ itself?

Sorry for bringing up an old thread.

[Lukas Eder]

Interesting, that must've been an oversight in https://github.com/jOOQ/jOOQ/issues/3985, or the function wasn't available at the time yet.

I've added a feature request for this:

https://github.com/jOOQ/jOOQ/issues/6108

Will be an easy fix.

To unsubscribe from this group and stop receiving emails from it, send an email to jooq-user+unsubscribe@googlegroups.com.

[Leandro Aparecido]

Great, thanks.

--
You received this message because you are subscribed to a topic in the Google Groups "jOOQ User Group" group.
To unsubscribe from this topic, visit https://groups.google.com/d/topic/jooq-user/O2P-jEMVlYA/unsubscribe.
To unsubscribe from this group and all its topics, send an email to jooq-user+unsubscribe@googlegroups.com.