Re: MySQL search query is not executing in Postgres DB

On Fri, Feb 17, 2012 at 9:01 AM, Marti Raudsepp <marti@juffo.org> wrote:
> On Fri, Feb 17, 2012 at 17:13, Adrian Klaver <adrian.klaver@gmail.com> wrote:
>> Why not use:
>> " SELECT * FROM <Table-name> WHERE CAST(Table.ID as TEXT) LIKE '1%' "
>>
>> as the MySQL query also?  MySQL supports the CAST function.
>
> Nope, trying to use CAST() in an interoperable manner is a lost cause.
> Sadly MySQL and PostgreSQL don't agree over the cast types. MySQL's
> CAST doesn't recognize varchar or text. Both support CHAR, but they
> work differently (MySQL's char behaves like PostgreSQL's varchar):

Have you tried casting to varchar(1000) or something like that?