Re: Using a composite SQL type in C

------=_Part_2577_18885070.1210266688103
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

Check the do***entation about using composite-type arguments in C
http://www.postgresql.org/docs/8.2/static/xfunc-c.html#AEN37402

You can use GetAttributeByNum() or GetAttributeByName() to get each value
from your custom type. You will need to get the HeapTupleHeader first by
calling PG_GETARG_HEAPTUPLEHEADER(). A quick google search brought up this
tutorial that might help http://linuxgazette.net/142/peterson.html

Cheers

>
> My problem is, how do I access this type in my function (in C), and how
do
> I create a new object of this type to return from the function?  I need
to
> store both a text and an int, to avoid doing an extra query around the
> result of this aggregate (to get the corresponding text value), which is
> what I'm currently doing.  Any ideas?
>
>

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

<div class="gmail_quote">
<p>Check the do***entation about using composite-type arguments in C <a
href="http://www.postgresql.org/docs/8.2/static/xfunc-c.html#AEN37402">http://www.postgresql.org/docs/8.2/static/xfunc-c.html#AEN37402</a></p>
<p>You can use GetAttributeByNum() or GetAttributeByName() to get each
value from your custom type. You will need to get the HeapTupleHeader
first by calling PG_GETARG_HEAPTUPLEHEADER(). A quick google search
brought up this tutorial that might help <a
href="http://linuxgazette.net/142/peterson.html">http://linuxgazette.net/142/peterson.html</a></p>

<p>Cheers</p>
<blockquote class="gmail_quote" style="PADDING-LEFT: 1ex; MARGIN: 0px 0px
0px 0.8ex; BORDER-LEFT: #ccc 1px solid"><br>My problem is, how do I access
this type in my function (in C), and how do I create a new object of this
type to return from the function? &nbsp;I need to store both a text and an
int, to avoid doing an extra query around the result of this aggregate (to
get the corresponding text value), which is what I&#39;m currently doing.
&nbsp;Any ideas?<br>
<br></blockquote></div>
<p><br>&nbsp;</p>

------=_Part_2577_18885070.1210266688103--