Hi
The following query displays the email correctly when run on a MySQL database, but it displays the email as follows when run on a Postgres database: bc2630c8bb9f2fad2ab86d7b2c7c0361
SELECT userid, prefix_logstore_standard_log.timecreated, action, courseid, lastname, email
FROM
prefix_user
LEFT JOIN prefix_logstore_standard_log ON prefix_user.id = prefix_logstore_standard_log.userid
WHERE userid = 3 AND courseid > 1
I am new to Postgresql, and I can't find any help on the web. So can anyone here help me please?
Both Moodle 2.8
Regards
Marinda