Postgres Pro
Downloads
Home   >   mailing lists

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

From Marti Raudsepp
Subject Re: MySQL search query is not executing in Postgres DB
Date
Msg-id CABRT9RBwB4BdhvEbZqFo1mp3a3gadLybhuAK5fMrs+fMemCU4g@mail.gmail.com
Whole thread Raw
In response to Re: MySQL search query is not executing in Postgres DB  (Scott Marlowe <scott.marlowe@gmail.com>)
Responses Re: MySQL search query is not executing in Postgres DB  (Scott Marlowe <scott.marlowe@gmail.com>)
List pgsql-general
Tree view 
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.

Regards,
Marti

pgsql-general by date:

Previous
From: Marti Raudsepp
Date:
Subject: Re: Set returning functions in select column list
Next
From: Alban Hertroys
Date:
Subject: Re: MySQL search query is not executing in Postgres DB