DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta;
	h=received:message-id:date:from:to:subject:mime-version:content-type;
	b=sJtqDxplzej6BORvSbx0U2/H4skGXzhexdbu+Immxj4zEn7fPr7789hK+nle4y4/KPAqZo9oxj4WnT5xttzxaHLo1bqeaTpRz/1acaKXXF35WCUdhACBuJnPF2TZ/eiewMVD7tgTVy11U9WGdAkLmVV6wKoGjTtKJOnJMtcO1oU=
Message-ID: <f5f60fb50705111834m40e8ce31o966d261ef66d9946@mail.gmail.com>
Date: Fri, 11 May 2007 18:34:20 -0700
From: "Rob Tester" <robtester@gmail.com>
To: pgsql-interfaces@postgresql.org
Subject: Help with returning a tuple
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_54374_3052840.1178933660946"

------=_Part_54374_3052840.1178933660946
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

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.

Thanks,

Rob.

------=_Part_54374_3052840.1178933660946
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

<div>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&nbsp;very large variable length string. I created a type on Postgres that&nbsp;contains two fields (int4 and text).&nbsp;Originally, I was using buildTupleFromCStrings().&nbsp;My function works fine and everything is cool, until my string becomes large. At that point&nbsp;NULL is returned in my&nbsp;tuple (I believe that&nbsp;this is because&nbsp;Postgres&nbsp;is using&nbsp;char type conversion on the string). So, my question is how can I return the large string as part of my tuple?&nbsp;Is there a Datum function that will allow me to convert a text* into a datum?&nbsp; Any help or&nbsp;a push in the right direction would be appreciated.
</div>
<div><br>Thanks,</div>
<div><br>Rob.&nbsp;&nbsp;</div>
<div>&nbsp;</div>
<div>&nbsp;</div>

------=_Part_54374_3052840.1178933660946--