Rafael Martinez <[EMAIL PROTECTED]> writes:
> We have a function in C which is accessed via a view and which produces
> a strange result when used together with || (String concatenation).
> I can not find the problem. Any C/postgres guru with any idea of how to
> fix it?
You need to set the size of the text result correctly. As is, you're
returning a 252-byte result containing embedded nulls and random
garbage. Embedded nulls, in particular, are verboten.
The fixed-size palloc is okay (as long as you're sure it's enough),
but the length word should only count valid data.
regards, tom lane
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
