acs-db-12-procs.tcl

Fix potential problems when calling polymorphic SQL functions from Tcl

Some functions are defined in the database with the same number of
arguments but different types, e.g., first argument "package_key"
(type text) or "package_id" (type integer). This is fine from the SQL
standpoint, but when calling from Tcl via bind-vars
(e.g. ":package_id"), everything is passed as a string, and
potentially, the wrong function is called.

Now, all the automatically generated subs are generated with casts,
when the integer based variant must be called.

Some examples:

Before:
set s [ns_pg_bind 0or1row $__DB {select apm__set_value(:package_id,:parameter_name,:attr_value)}]
set s [ns_pg_bind 0or1row $__DB {select apm__get_value(:package_id,:parameter_name)}]

Now:
set s [ns_pg_bind 0or1row $__DB {select apm__set_value(CAST(:package_id AS integer),:parameter_name,:attr_value)}]
set s [ns_pg_bind 0or1row $__DB {select apm__get_value(CAST(:package_id AS integer),:parameter_name)}]

- bumped version number to 5.10.1b11