Re: SQL compatibility reminder: MySQL vs PostgreSQL

Поиск
Список
Период
Сортировка
От Hitoshi Harada
Тема Re: SQL compatibility reminder: MySQL vs PostgreSQL
Дата
Msg-id e08cc0401003080914i61c492c7jb2cccd7865331217@mail.gmail.com
обсуждение исходный текст
Ответ на Re: SQL compatibility reminder: MySQL vs PostgreSQL  (Jaime Casanova <jcasanov@systemguards.com.ec>)
Список 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 по дате отправления:

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: SQL compatibility reminder: MySQL vs PostgreSQL
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Safe security