Postgresql vs Mysql: display email (Ad hoc database query)

Postgresql vs Mysql: display email (Ad hoc database query)

by Marinda Faasen -
Number of replies: 0

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

Average of ratings: -