Hi,
If I do this:
concat(ATHLETE.club().ABBREVIATION, field(" "), ATHLETE.club().NAME)
I get
(("alias_128651403"."abbreviation" || cast( as varchar)) ||
"alias_128651403"."name")
Which results in
org.springframework.jdbc.BadSqlGrammarException: jOOQ; bad SQL grammar
[select "public"."athlete"."id", "public"."athlete"."first_name",
"public"."athlete"."last_name", (("alias_128651403"."abbreviation" || cast(
as varchar)) || "alias_128651403"."name") from ("public"."athlete" left
outer join "public"."club" as "alias_128651403" on
"public"."athlete"."club_id" = "alias_128651403"."id") order by
"public"."athlete"."first_name", "public"."athlete"."last_name" offset ?
rows fetch next ? rows only]
at org.jooq_3.19.13.POSTGRES.debug(Unknown Source) ~[na:na]
To make it work I have to use
concat(ATHLETE.club().ABBREVIATION, field("' '"), ATHLETE.club().NAME)
Why?
Thanks, Simon
--
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].
To view this discussion visit
https://groups.google.com/d/msgid/jooq-user/5c8aa7ca-75cc-4230-a6b1-8fc526343dc4n%40googlegroups.com.
