Re: MySQL search query is not executing in Postgres DB - Mailing list pgsql-general

From Scott Marlowe
Subject Re: MySQL search query is not executing in Postgres DB
Date
Msg-id CAOR=d=0iZ+5tkfmW164w_g_MxuOORTkGoORKu1=DngMwuT+cew@mail.gmail.com
Whole thread Raw
In response to Re: MySQL search query is not executing in Postgres DB  (Marti Raudsepp <marti@juffo.org>)
List pgsql-general
On Fri, Feb 17, 2012 at 9:22 AM, Marti Raudsepp <marti@juffo.org> wrote:
> On Fri, Feb 17, 2012 at 18:19, Scott Marlowe <scott.marlowe@gmail.com> wrote:
>> Have you tried casting to varchar(1000) or something like that?
>
> MySQL's CAST() doesn't accept varchar or varchar(N). It accepts char,
> which behaves like varchar.

It's a shame you can't file a mysql bug report and get a patch in a
reasonable amount of time like you can with pgsql*.

(* I've filed two bug reports and gotten patches in < 24 hours both
times with pgsql.)

pgsql-general by date:

Previous
From: Alban Hertroys
Date:
Subject: Re: MySQL search query is not executing in Postgres DB
Next
From: Jerry Levan
Date:
Subject: Pokey Fedora Updates for Postgresql?