On Thu, Oct 29, 2015 at 1:56 PM, Adrian Klaver <adrian.kla...@aklaver.com> wrote:
> On 10/29/2015 10:47 AM, Dane Foster wrote: > >> Hello, >> >> I have a MySQL/PHP app that I want to port to PostgreSQL so I just >> installed the mysql_fdw from https://github.com/EnterpriseDB/mysql_fdw >> because I'd like to do the data migration in SQL if possible. >> >> Installation and set up worked flawlessly but when I run the following >> query >> SELECT >> title, >> description, >> '[' || starts || ', ' || COALESCE(ends, 'infinity') || ']' >> FROM >> _filler >> WHERE >> starts IS NOT NULL >> AND description IS NOT NULL >> AND LENGTH(TRIM(title)) > 0 >> AND LENGTH(TRIM(description)) > 0; >> >> I get the following error: >> >> >> ERROR: failed to prepare the MySQL query: >> FUNCTION latest.btrim does not exist >> >> FYI: Tables names that start w/ _ are the MySQL versions of PostgreSQL >> tables. >> >> >> Any help would be appreciated. >> > > What version of Postgres are you using? > > >> Thanks, >> >> >> Dane >> > > > -- > Adrian Klaver > adrian.kla...@aklaver.com > My bad. I should know better. It's PostgreSQL 9.5beta1 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 4.9.2-10ubuntu13) 4.9.2, 64-bit Thanks, Dane