Hi, We are using jooq for generating sql statements for a postgres data store. And for string literals we are following the postgres convention of dollar quoting ( http://www.postgresql.org/docs/current/static/sql-syntax-lexical.html). jooq doesn't seem to be respecting the dollar quoted strings of postgres.
Internally within our system all the string literals are dollar quoted. For instance, when given a string which has a single quote (special character) in it - for example *"it's"* we would dollar quote it to $zLmv$*it's*$zLmv. However jooq converts such a string to $zLmv$*it''s*$zLmv during query generation (note that it adds an additional apostrophe). Is there a way to tell jooq not to handle any special characters within strings as we have handled it ourselves through dollar quoting ? Any help would be appreciated. Thanks! -- 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/groups/opt_out.
