On Thu, Oct 29, 2015 at 1:56 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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.klaver@xxxxxxxxxxx
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
