Re: SQL compatibility reminder: MySQL vs PostgreSQL - Mailing list pgsql-hackers

From Hitoshi Harada
Subject Re: SQL compatibility reminder: MySQL vs PostgreSQL
Date
Msg-id e08cc0401003080914i61c492c7jb2cccd7865331217@mail.gmail.com
Whole thread Raw
In response to Re: SQL compatibility reminder: MySQL vs PostgreSQL  (Jaime Casanova <jcasanov@systemguards.com.ec>)
List pgsql-hackers
2010/3/9 Jaime Casanova <jcasanov@systemguards.com.ec>:
> On Mon, Mar 8, 2010 at 4:17 AM, Pierre C <lists@peufeu.com> wrote:
>>
>>> My opinion is that PostgreSQL should accept any MySQL syntax and return
>>> warnings. I believe that we should access even innodb syntax and turn it
>>> immediately into PostgreSQL tables. This would allow people with no
>>> interest in SQL to migrate from MySQL to PostgreSQL without any harm.
>>
>> A solution would be a SQL proxy (a la pgpool) with query rewriting.
>>
>
> This sounds like a better idea...

Could parser & rewriter hook be another solution here?
I'm completely against the wrong GROUP BY syntax from MySQL, but it is
also true that SQL is only an interface.

-- 
Hitoshi Harada


pgsql-hackers by date:

Previous
From: David Fetter
Date:
Subject: Re: SQL compatibility reminder: MySQL vs PostgreSQL
Next
From: Tom Lane
Date:
Subject: Re: Safe security