Differences between Postgres and MySql

Поиск
Список
Период
Сортировка
От John Gage
Тема Differences between Postgres and MySql
Дата
Msg-id EB32DDE9-521B-4391-A95A-185DA3F3901E@numericable.fr
обсуждение исходный текст
Ответ на Re: Need Some Recent Information on the Differences between Postgres and MySql  (Thomas Kellerer <spam_eater@gmx.net>)
Ответы Re: Differences between Postgres and MySql  (Scott Marlowe <scott.marlowe@gmail.com>)
Список pgsql-general
> John Gage, 25.06.2010 11:50:
>> I am astonished to discover that MySQL does not support
>> regular expressions much less something like tsvector.
>
> Getting really off-topic now: but MySQL does support Regex
>
> http://dev.mysql.com/doc/refman/5.1/en/regexp.html

I have done an extensive comparison between MySQL's support for regexp
and Postresql's and, frankly, there is no comparison.  The support in
Postgresql is far greater than in MySQL.  This is not a flame.  It is
intended to help anyone choosing between the two programs.

The best example I can present is the regexp_split_to_table function
in Postgres.  I use it all the time.  It is enormously convenient.
Anyone analyzing text is ecstatic to have such a powerful function
readily available.

This is a qualitative difference.

John



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

Предыдущее
От: Osvaldo Kussama
Дата:
Сообщение: Re: How to import *.sql file to postgresql database
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Full Text Search ideas