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: (view raw, whole thread or download thread mbox)
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"

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

Michael Fuhr

In response to


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-2018 The PostgreSQL Global Development Group