NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
== Upgrading Views from mySQL to PostreSQL ==__NOEDITSECTION__
When upgrading from {{IMSMANG}} 5.08.04 to 6.0, the database views need to be adapted, i.e. changed from mySQL syntax to PostgreSQL syntax. The country focal point is taking care of this. For reference, this section describes the main changes encountered. This can also be used as a tutorial for creating views in PostgreSQL, for {{IMSMANG}} administrators who were used to creating them in mySQL.
=== Case sensitivity and column names ===__NOEDITSECTION__
=== The GROUP BY clause ===__NOEDITSECTION__
=== IF and IFNULL (mySQL) / CASE (PostgreSQL) statements ===__NOEDITSECTION__
=== Date manipulations ===__NOEDITSECTION__
=== CAST AS CHAR utf8 (mySQL) ===__NOEDITSECTION__
{{NavBox Technical Notes}}
[[Category:NAA]]