NoPublic, bureaucrat, administrator
1,068
edits
Changes
no edit summary
== Introduction ==__NOEDITSECTION__
{{IMSMANG}} version 6.0 is building on a PostgreSQL database management system, whereas previous {{IMSMANG}} versions were built on a MySQL database. Both systems are relational database systems and using SQL, the Structured Query Language, as means for interacting with it. However, there are same differences between MySQL and PosrgreSQL syntaxes.
The biggest differences are:
* PostGreSQL PostgreSQL is case sensitive* Command/functionBuilt-in functions (e.g. conditional expressions)* Dates are stored without format in PostGreSQL* Round off and time formats and queries* Customised Custom functions
== Changes in database views from MySQL to PostreSQL ==__NOEDITSECTION__