Hi Walid,
Thanks for your message. We don't support that function yet. I've added it
to the feature request here, which was about REGEX_SUBSTR():
https://github.com/jOOQ/jOOQ/issues/11698
You'll have to implement support in your ParseListener implementation for
now
Thanks,
Lukas
On Fri, Apr 23, 2021 at 10:04 AM Walid CHAIB <walidchai...@gmail.com> wrote:
> Hi Lukas,
>
> I hope you are doing well.
> I wonder if Jooq needs a specific parameter to parse this function
> Regexp_instr().
> Because when i execute this request on Postgresql via Jooq.
>
> SELECT
> CASE
> WHEN c.masq_comp = 'Date' THEN
> CASE
> WHEN regexp_instr(i.LIGN_RIS, '[0-3][0-9]/[0-1][0-9]/[1-2][0|9][0-9]{2}')=
> 1 THEN to_char(to_date(i.LIGN_RIS, 'DD/MM/YYYY'), 'dd/mm/yyyy')
> WHEN regexp_instr(i.LIGN_RIS, '[0-3][0-9]-[0-1][0-9]-[1-2][0|9][0-9]{2}')=
> 1 THEN to_char(to_date(i.LIGN_RIS, 'DD-MM-YYYY'), 'dd/mm/yyyy')
> WHEN regexp_instr(i.LIGN_RIS, '[1-2][0|9][0-9]{2}-[0-1][0-9]-[0-3][0-9]')=
> 1 THEN to_char(to_date(i.LIGN_RIS, 'YYYY-MM-DD'), 'dd/mm/yyyy')
> WHEN regexp_instr(i.LIGN_RIS, '[1-2][0|9][0-9]{2}[0-1][0-9][0-3][0-9]')= 1
> THEN to_char(to_date(i.LIGN_RIS, 'YYYYMMDD'), 'dd/mm/yyyy')
> ELSE i.LIGN_RIS
> END
> ELSE i.LIGN_RIS
> END LIGN_RIS, c.TABL_COMP
> FROM RISQUE i
> INNER JOIN COMPOSANTWEB c ON
> c.CD_COMP = i.CD_COMP
> WHERE i.id_pol =:IDPOL
> AND c.tabl_comp LIKE 'RISQUE.%'
>
> I get an exception caused by the regexp_instr() function.
>
> Thanks in advance,
> Walid
>
>
> --
> 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+unsubscr...@googlegroups.com.
> To view this discussion on the web visit
> https://groups.google.com/d/msgid/jooq-user/CAOP4Xxjv0PrQdaiUM622G8NVbEyWrooicakc0PCw-EQP9fUFvg%40mail.gmail.com
> <https://groups.google.com/d/msgid/jooq-user/CAOP4Xxjv0PrQdaiUM622G8NVbEyWrooicakc0PCw-EQP9fUFvg%40mail.gmail.com?utm_medium=email&utm_source=footer>
> .
>
--
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+unsubscr...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/jooq-user/CAB4ELO6tMZ_VStFUZckEg8fW-ATFtxTG2SYzVfaqXtWStUSC%2BQ%40mail.gmail.com.
