Re: Returning a long string (varchar from a function)

On Wed, Feb 09, 2005 at 12:30:51PM -0500, Oisin Glynn wrote:
>
> select * from zfunc_test(254);
> Gets chopped off to '...aaaa25'

I couldn't duplicate this problem -- I get the entire string. Maybe
your client is truncating the value -- how are you communicating
with the database?

Regarding what your function does, are you familiar with the repeat()
function described in the "String Functions and Operators"
documentation?

http://www.postgresql.org/docs/8.0/static/functions-string.html

SELECT repeat('a', 10);
repeat
------------
aaaaaaaaaa
(1 row)

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/