RE: PostgreSQL compatibility fixes

This message was sent from: Development
http://forums.oscommerce.com/viewtopic.php?p=220183#220183
----------------------------------------------------------------

[quote="cannuck1964"]hi
I am not sure, but it looked like the original work was going towards this at one time, but I think the team is only looking at using MySQL now.  Take for exapmle the function tep_merge_array,  This was done in the DB layer, but now has been removed, since MySQL now supports array merging.....
[/quote]
AFAIK it is/was targeted after the 2.2 release.

[quote="cannuck1964"]hi
The abstract layer I was looking at is contained in the POST NUKE project,  it might be an idea to look over it and see if it can be modified to be used with osc.
[/quote]
Experminting with different solutions would be a good idea, the PEAR solution is causing a bit of overhead and I have been thinking about replacing it with straight pg_* php funtions.

[quote="cannuck1964"]
I am not quite sure by what you mean by the term subqueries, can you explain what you mean here, and are they necessary to perform what is needed by osc?
[/quote]
I'm not sure but didn't MySQL just recently get the ability to do subselects? E.g.
SELECT * FROM addresses WHERE contact_id = (SELECT id FROM contacts WHERE nick = 'cannuck1964');

I think pokryfka was referring to that

Cheers,
Rob