Re: Postgres and MySQL Rosetta stone??

From: Ron Mayer <rm_pg(at)cheapcomplexdevices(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgres and MySQL Rosetta stone??
Date: 2008-01-10 19:00:05
Message-ID: fm5pv0$21k1$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Scott Marlowe wrote:
>> In particular, MySQl seems to have richer string functions to parse
>> out sub strings and als trim a string for automatic table insertion
>> from long multifield strings.
>
> Have you read the postgresql manual on string functions? Seriously,
> it's easily a match for MySQL in that arena, and beats it hands down
> in a few.

And if you need more - like extracting Noun Clauses from sentences
you can do that with PostgreSQL and Pl/Perl using natural language
processing libraries that are callable from perl.

I'd be interested to know how MySQL would handle that kind
of string processing function.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2008-01-10 19:08:57 Re: 8.2.4 serious slowdown
Previous Message Ron Mayer 2008-01-10 18:47:54 Re: count(*) and bad design was: Experiences with extensibility