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