Re: SQL compatibility reminder: MySQL vs PostgreSQL

Поиск
Список
Период
Сортировка
От Robert Haas
Тема Re: SQL compatibility reminder: MySQL vs PostgreSQL
Дата
Msg-id 603c8f071003080918n26f521flded1fa4607bf3405@mail.gmail.com
обсуждение исходный текст
Ответ на Re: SQL compatibility reminder: MySQL vs PostgreSQL  (David Fetter <david@fetter.org>)
Ответы Re: SQL compatibility reminder: MySQL vs PostgreSQL  (David Fetter <david@fetter.org>)
Re: SQL compatibility reminder: MySQL vs PostgreSQL  (Andrew Dunstan <andrew@dunslane.net>)
Список pgsql-hackers
On Mon, Mar 8, 2010 at 12:10 PM, David Fetter <david@fetter.org> wrote:
> On Mon, Mar 08, 2010 at 11:58:20AM -0500, Jaime Casanova wrote:
>> 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...
>
> Aside from that little "halting problem" issue, it sounds wonderful.
> You do know that SQL is Turing-complete, right?

That seems largely irrelevant to the problem at hand.  It's not
impossible to do syntactic transformations from one Turing-complete
langauge to another; if it were, there could be no such thing as a
compiler.

...Robert


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Safe security
Следующее
От: Tim Bunce
Дата:
Сообщение: Re: Safe security