Thread: Returning text from stored procedures??

Returning text from stored procedures??

From
Steffen Nielsen
Date:
Hi!

I seem to have trouble returning large strings of text from stored procedures 
(coded in C), It works fine for smaller data?
And elog prints out the result nicely; but when the result is "returned" it 
makes the server disconnect???? I use the standard Datum methods (actually 
I've tried any possible way returning the damn text :-( ).

Any Ideas why? Are there restriction on the size of text a stored procedure 
can return?

Any help is appreciated :-)

/Steffen Nielsen



Re: Returning text from stored procedures??

From
Tom Lane
Date:
Steffen Nielsen <styf@cs.auc.dk> writes:
> Any Ideas why? Are there restriction on the size of text a stored procedure 
> can return?

One gig ...

It's hard to guess what you're doing wrong when you haven't shown us
your code.
        regards, tom lane