On Fri, Feb 17, 2012 at 9:22 AM, Marti Raudsepp <marti@xxxxxxxxx> wrote: > On Fri, Feb 17, 2012 at 18:19, Scott Marlowe <scott.marlowe@xxxxxxxxx> 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. It's a shame you can't file a mysql bug report and get a patch in a reasonable amount of time like you can with pgsql*. (* I've filed two bug reports and gotten patches in < 24 hours both times with pgsql.) -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general