On 02/17/2012 08:01 AM, Marti Raudsepp wrote:
On Fri, Feb 17, 2012 at 17:13, Adrian Klaver<adrian.klaver@xxxxxxxxx> 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@xxxxxxxxx
--
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
