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

Re: Trouble returning a text field from an SRF

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Rob Tester" <robtester(at)gmail(dot)com>
Cc: "'Alvaro Herrera'" <alvherre(at)commandprompt(dot)com>, pgsql-interfaces(at)postgresql(dot)org
Subject: Re: Trouble returning a text field from an SRF
Date: 2007-05-15 00:24:53
Message-ID: 1681.1179188693@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-interfaces
"Rob Tester" <robtester(at)gmail(dot)com> writes:
> I have tried this using pgadmin3 (v1.6.1) and npgsql with the same results,
> no data returned in the text field when the data goes over 65535 chars.
> Maybe both clients are incorrectly setting a limit on a text field?

What happens when you try it in plain old psql?

			regards, tom lane

In response to

pgsql-interfaces by date

Next:From: Sandeep KhandelwalDate: 2007-05-15 09:11:00
Subject: COPY command with bad input
Previous:From: Rob TesterDate: 2007-05-14 23:35:23
Subject: Re: Trouble returning a text field from an SRF

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