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: ' ||
to_char(total,'99999999999999999999999999999999999999');
...
DBD::Pg::st pg_result failed: ERROR:  operator is not unique: unknown ||
integer
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
Bucardo-general@bucardo.org
https://mail.endcrypt.com/mailman/listinfo/bucardo-general

Reply via email to