Re: Concat truncates at 257 characters

More details please.

> The problem is that the concat and || are truncating the result.

No, that is not the case:

select length(cast( rpad('', 200, 'A')::text || rpad('', 200, 'B')::text as
text )) -- output -> 400

SELECT length(repeat('a', 50) || repeat('b', 200) || repeat('c', 100)) --
output -> 350

> My automated database unit tests compare the actual result to the expected
> result then provides a pass or fail status.

So some client-side interface is where the problem resides. It is trying to
output more user-friendly content for extra-long strings.

David J.

--
View this message in context: http://postgresql.1045698.n5.nabble.com/Concat-truncates-at-257-characters-tp5780244p5780248.html
Sent from the PostgreSQL - bugs mailing list archive at Nabble.com.