DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:from:to:cc:references:in-reply-to:subject:date:message-id:mime-version:content-type:content-transfer-encoding:x-mailer:thread-index:content-language;
	b=XcY7hlGlpribOOpB3/mtA2BNluIw3A29vjD0iEZVf6ASliJs59DgabNFSoa4/+G4noNs5qvCckKrOVRAlC1TJhWbd737LfJtBPZ3AIsVUNwge67GQDjV1OfKvawjPiSC37UrIAyemcIDCug569SZX3tYtPwqWANvcj0oEXgqCxk=
From: "Rob Tester" <robtester@gmail.com>
To: "'Alvaro Herrera'" <alvherre@commandprompt.com>
Cc: <pgsql-interfaces@postgresql.org>
References: <f5f60fb50705120826q7e08c426offc9268bb776e8b6@mail.gmail.com>
	<20070513181154.GB11750@alvh.no-ip.org>
In-Reply-To: <20070513181154.GB11750@alvh.no-ip.org>
Subject: Re: Trouble returning a text field from an SRF
Date: Mon, 14 May 2007 13:47:52 -0700
Message-ID: <07ec01c79669$25dad7a0$719086e0$@com>
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
thread-index: AceVijFjUCYZYcyMTMyjEURgAu+5LwA3uM/g
Content-Language: en-us

I created my tuple that way and set the Datum using
DirectFunctionCall1(...), but there still seems to be a limitation at =
65535
chars for the data. When my string is 65535 (or shorter) I get the text
back. When it is longer I get nothing for the string, but the rest of =
the
tuple is intact.


My tuple descriptor:

CREATE TYPE testText AS
   (alevel integer,
    someText text);

Code in my pgLib extension:

//Code that handles the initial SRF stuff omitted
.
.
.
.

textOut=3Dpalloc(MIN_SIZE*count);
if (textOut){
	strcpy(textOut,"TEST=3D>");
	for(pointCnt=3D0;pointCnt<count;pointCnt++){
		if (pointCnt!=3D0){
			strcat(wktStr,",");
		}
		sprintf(buffer,"%4.8lf %4.8lf",0.0,0.0);
		strcat(textOut,buffer);
	}
	strcat(wktStr,"=3D=3D>END");

	values[0]=3D Int32GetDatum(strlen(textOut));
	values[1]=3D DirectFunctionCall1(textin,PointerGetDatum(textOut));

	tuple=3Dheap_formtuple(tupDesc, values, nulls);

	result =3D HeapTupleGetDatum(tuple);


	SRF_RETURN_NEXT(funcctx, result);
}
.

.
.
.


This function works great as long as strlen(textOut)<=3D65535 after =
that, I
get nothing for the someText value in my return type.


Any thoughts on how to get the rest of my strings when they are over =
65535
bytes in length?

-----Original Message-----
From: Alvaro Herrera [mailto:alvherre@commandprompt.com]=20
Sent: Sunday, May 13, 2007 11:12 AM
To: Rob Tester
Cc: pgsql-interfaces@postgresql.org
Subject: Re: [INTERFACES] Trouble returning a text field from an SRF

Rob Tester escribi=F3:
> I have written several postgres extensions in the past. =
However,currently
I
> am having difficulty with an extension returning a tuple. Basically I =
want
> to return a tuple containing an integer and a very large variable =
length
> string. I created a type on Postgres that contains two fields (int4 =
and
> text). Originally, I was using buildTupleFromCStrings(). My function =
works
> fine and everything is cool, until my string becomes large. At that
> point NULL is returned in my tuple (I believe that this is
> because Postgres is using char type conversion on the string). So, my
> question is how can I return the large string as part of my tuple? Is
there
> a Datum function that will allow me to convert a text* into a datum?  =
Any
> help or a push in the right direction would be appreciated.

You can use things like

DirectFunctionCall1(textin, CStringGetDatum(the-c-string))
which returns a Datum containing a Text with the C-string in it.

I would normally try to use heap_form_tuple instead of
buildTupleFromCStrings if possible, but I wouldn't think that the latter
would fail on too large texts.  It's hard to say what's failing without
actually seeing the code anyway.  Maybe the problem is failure to handle
TOAST at some level.

--=20
Alvaro Herrera                                =
http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.