Re: CONCAT with single blank

[Alf Lervåg]

You should be using val or inline for value literals. I’d go for the latter in this situation. Alf Lervåg 27. okt. 2024 kl. 16:31 skrev Simon Martinelli <simon.martine...@gmail.com>: 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 jooq-user+unsubscr...@googlegroups.com. To view this discussion visit https://groups.google.com/d/msgid/jooq-user/5c8aa7ca-75cc-4230-a6b1-8fc526343dc4n%40googlegroups.com. -- 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 visit https://groups.google.com/d/msgid/jooq-user/1CBB45B3-25A1-4405-9021-56E34F9CB4A0%40lervag.net.