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

From Adrian Klaver
Subject Re: MySQL search query is not executing in Postgres DB
Date
Msg-id 4F3EC382.2020101@gmail.com
Whole thread Raw
In response to Re: MySQL search query is not executing in Postgres DB  (Marti Raudsepp <marti@juffo.org>)
Responses Re: MySQL search query is not executing in Postgres DB
List pgsql-general
On 02/17/2012 08:01 AM, Marti Raudsepp 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):
>

Well I guess the choices are put back the implicit cast or change the
data type of the Table.ID column in Postgres to varchar.

>
>
> Regards,
> Marti


--
Adrian Klaver
adrian.klaver@gmail.com

pgsql-general by date:

Previous
From: Andy Colson
Date:
Subject: Re: select as params to function
Next
From: Tom Lane
Date:
Subject: Re: Pokey Fedora Updates for Postgresql?