| From: | Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> |
|---|---|
| To: | Marti Raudsepp <marti(at)juffo(dot)org> |
| Cc: | Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org, premanand <kottiprem(at)gmail(dot)com> |
| Subject: | Re: MySQL search query is not executing in Postgres DB |
| Date: | 2012-02-17 17:20:03 |
| Message-ID: | CAOR=d=0iZ+5tkfmW164w_g_MxuOORTkGoORKu1=DngMwuT+cew@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Fri, Feb 17, 2012 at 9:22 AM, Marti Raudsepp <marti(at)juffo(dot)org> wrote:
> On Fri, Feb 17, 2012 at 18:19, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)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.)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Jerry Levan | 2012-02-17 19:32:54 | Pokey Fedora Updates for Postgresql? |
| Previous Message | Alban Hertroys | 2012-02-17 16:24:55 | Re: MySQL search query is not executing in Postgres DB |