Hi all. I've recently had to port a series of webapps from MySQL to PostgreSQL, and it's going surprisingly smoothly (thank you ADOdb!!!!), but I've run into a problem with one query:
I've set $conn->debug = 1 so I can see each query as it's executed, and here's what's happening:
(mysql):
select j., t.job_type, ed.level, h.hours, emp.
from jb_jobs j, jb_job_types t, jb_education_levels ed, jb_hours_types h, jb_employers emp
where j.job_type = t.job_type_id
and j.education_levels = ed.level_id
and j.hours = h.hours_id
and j.emp_id = emp.emp_id
and j.job_id = 287
and this returns one record.
(postgres):
select j., t.job_type, ed.level, h.hours, emp.
from jb_jobs j, jb_job_types t, jb_education_levels ed, jb_hours_types h, jb_employers emp
where j.job_type = t.job_type_id
and j.education_levels = ed.level_id
and j.hours = h.hours_id
and j.emp_id = emp.emp_id
and j.job_id = 287
and this returns no records.
Now, the record with job_id 287 exists in both databases, and the table and datastructures for all other entities in the query are identical.
Can anyone see any reason why the query in PostgreSQL isn't returning any result?
Thanks in advance,
Pablo
