OpenACS / openacs-4 / packages / acs-events / sql / postgresql / upgrade

upgrade-0.6.2d7-0.6.2d8.sql

Tree
Options

oacs-5-10:gustafn:20240819134832

Fixed variable names for SQL functions to allow to call these directly from Tcl

---
--- Fix SQL function that were defined with the same number of
--- arguments and the same argument names, but receiving different
--- types (integers vs. timespans). This is fine, as long the
--- functions are only called from SQL and positional arguments. When
--- calling from Tcl, this does not work.
---
--- This change uses in cases, where offsets are specified as
--- intervals the suffix "_interval" for the variable names, keeping
--- the names without this suffix for integer arguments (for Oracle
--- compatibility).

19 Aug gustafn oacs-5-10:gustafn:20240819134832

MAIN:gustafn:20240819134832

file upgrade-0.6.2d7-0.6.2d8.sql was initially added on branch oacs-5-10.

19 Aug gustafn MAIN:gustafn:20240819134832

Loading ...