Databases

---

How to insert a literal single quote into IBM Netcool/OMNIbus ObjectServer   Recently updated !

This entry was posted in Databases NMS and tagged netcool on 31.08.2026 by Christian Ramseyer

$ nco_sql -user netcool1> update custom.filterclauses set sqlclause = ‘EventClass = \’Tech Event\” where clauseid = 262> go(1 row affected) This detail seems to be missing from the manual and is somewhat hard to find otherwise. Other variants like doubling ” or concatenating a char(39) function will not work.

---

PostgreSQL: Create a sum() aggregate for text columns

This entry was posted in Databases Linux on 16.10.2018 by Christian Ramseyer

Recently one of our clients wanted to aggregate text data in PostgreSQL using Mondrian. Without going too deep into Mondrian details, this requires an aggregate function that’s called sum() and accepts a single text argument. While stock PostgreSQL fulfills the first criteria, the function is defined for many data types but not text. Creating some […]

---

---