You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
will return error io.vertx.pgclient.PgException: function generate_series(unknown, unknown) is not unique
This happens because while all of the queries are turned into prepared statements by AbstractReactiveQueryExecutor.toPreparedQuery() using ParamType.NAMED, such usage isn't allowed in cases of postgres polymorphic functions like generate_series. The usage for such functions in prepared statements is possible only with explicitly cast parameters, e.g. generate_series($1::int,$2::int), while they work without any issues in regular statements.
The text was updated successfully, but these errors were encountered:
The following call:
will return error io.vertx.pgclient.PgException: function generate_series(unknown, unknown) is not unique
This happens because while all of the queries are turned into prepared statements by
AbstractReactiveQueryExecutor.toPreparedQuery()
usingParamType.NAMED
, such usage isn't allowed in cases of postgres polymorphic functions like generate_series. The usage for such functions in prepared statements is possible only with explicitly cast parameters, e.g.generate_series($1::int,$2::int)
, while they work without any issues in regular statements.The text was updated successfully, but these errors were encountered: