[phpBT-dev] Mysql <-> Postgresql

[Javier S. <js...@si...>]

  I was working on support request for postgresql  :-)

I have solve the basic error from template extends, i have just change 
conditional synatx (IF is not compatible whith pgsql, but CASE works 
with both)
There is many bugs like this ... when we use some specific Mysql 
function ..like CONCAT ... or LIMIT ... this cause a lot of errors on 
pgsql ...
It is not a simple thing to make compatible SQL queries between 
differents DB types ...

Mysql  : CONCAT('str1','str2')  >  Pgsql  'str1' || 'str2'

Mysql  :

This example will limit the result to 10 rows, starting with row 5.
SELECT name FROM customers LIMIT 5 , 10

Pgsql  : 

This example will limit the result to 5 rows, starting with row 10.
SELECT name FROM customers LIMIT 5 , 10

This limit problem is a big problem .... There is two solutions :

->Each Query can be simplified

OR

->Code must use different queries in funtion of DB type

Any other ideas are welcome !


Funny Game :-P