search

3ilogiclms / moodle-block_learning_plan

This plugin serves as a database and plan for all learning activities in the organziation, where such activities are organized for a more structured learning program.
8 stars 12 forks source link

adds compatibility with postgresql #10

Closed claudebossy closed 8 years ago

claudebossy commented 9 years ago

The current implementation is not working with PostgreSQL databases. This is a short explanation why:

MySQL uses ' or " to quote values (i.e. WHERE name = "John"). This is not the ANSI standard for databases. PostgreSQL uses only single quotes for this (i.e. WHERE name = 'John'). Double quotes are used to quote system identifiers; field names, table names, etc. (i.e. WHERE "last name" = 'Smith').

3ilogiclms commented 9 years ago

Hi, Thanks for your contribution. We will review your code and then get back to you.

Regards, 3i Logic LMS Team