Re: Differences between Postgres and MySql

On Sun, Jul 18, 2010 at 2:13 PM, John Gage <jsmgage(at)numericable(dot)fr> wrote:
>> 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.

That and array_accum (in the docs in 8.3 I think it's built in now)
make life a breaze for making reports. No need for post query data
mangling, I get it out just the way I need it.