I have tried this:

RETURN 'Tables processed: ' || total::text;

it works.

Thank you for your response.

P.s.: In my environment "SELECT version();" returns:

"PostgreSQL 9.4.8 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 4.9.2-10) 4.9.2, 64-bit"

On 09/22/2016 05:26 PM, Greg Sabino Mullane wrote:
RETURN 'Tables processed: ' ||
DBD::Pg::st pg_result failed: ERROR:  operator is not unique: unknown ||
I think this might be solved easier with a force-cast to text like so:

RETURN 'Tables processed: '::text || total;

Could you see if that is a valid solution for your version of Postgres?

Bucardo-general mailing list

Reply via email to