Re: MySQL search query is not executing in Postgres DB

From: Marti Raudsepp <marti(at)juffo(dot)org>
To: Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com>
Cc: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>, pgsql-general(at)postgresql(dot)org, premanand <kottiprem(at)gmail(dot)com>
Subject: Re: MySQL search query is not executing in Postgres DB
Date: 2012-02-17 16:22:34
Message-ID: CABRT9RBwB4BdhvEbZqFo1mp3a3gadLybhuAK5fMrs+fMemCU4g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Feb 17, 2012 at 18:19, Scott Marlowe <scott(dot)marlowe(at)gmail(dot)com> 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.

Regards,
Marti

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alban Hertroys 2012-02-17 16:24:55 Re: MySQL search query is not executing in Postgres DB
Previous Message Marti Raudsepp 2012-02-17 16:21:07 Re: Set returning functions in select column list