Skip site navigation (1) Skip section navigation (2)

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

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Oisin Glynn <me(at)oisinglynn(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Returning a long string (varchar from a function)
Date: 2005-02-09 17:51:35
Message-ID: 20050209175135.GA19771@winnie.fuhr.org (view raw or flat)
Thread:
Lists: pgsql-novice
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/

In response to

Responses

pgsql-novice by date

Next:From: Bruce MomjianDate: 2005-02-09 18:09:59
Subject: Re: pg_hba.cong edit
Previous:From: Michael FuhrDate: 2005-02-09 17:38:28
Subject: Re: Last ID Problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group