RE: PostgreSQL compatibility fixes

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

hi

[quote]as a matter of fact osc has kind of abstract db layer 
but it doeasn't make much difference if the queries are uncorrect 
if one uses subqueries (ansi sql) then it will not work on mysql[/quote]

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.....

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.

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?

cheers,