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 some differences between the MySQL and PosrgreSQL syntaxessyntax. It is not possible to list all differences here, but the main ones encountered in the {{IMSMANG}} world are highlighted below.
The biggest differences are:
* PostgreSQL is case sensitive
* Dates and time formats and queries
* Custom functions
For more details about the PostgreSQL syntax it is advised to consult the official PostgreSQL documentation.
== Changes in database views from MySQL to PostreSQL ==__NOEDITSECTION__
=== The GROUP BY clause ===__NOEDITSECTION__
== References ==__NOEDITSECTION__
* PostgreSQL 1.9.4 documentation: http://www.postgresql.org/docs/9.1/static/index.html
{{NavBox Technical Notes}}
[[Category:NAA]]