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