Re: Custom Base Type in C

------=_Part_12102_31109090.1210205686552
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

If I make it pass-by-reference and varlena do I have to worry about
TOASTin=
g
and deTOASTing everying in my INPUT and OUTPUT functions?


On Wed, May 7, 2008 at 5:15 PM, Alvaro Herrera
<alvherre@[EMAIL PROTECTED]
>
wrote:

> Toby Chavez escribi=F3:
>
> > My custom type needs to have one biginteger and one text value...
prett=
y
> > straight forward. I guess my first question is if there are any
example=
s
> out
> > there that do something similar. I have looked extensively through the
> > contrib directory and can't find anything very helpful. If not, could
> > someone help me understand what my c struct would look like and what
> values
> > I need for INTERNALLENGTH, ALIGNMENT, STORAGE, etc in the CREATE TYPE
> > command?
>
> Probably what's biting you is that the type needs to be
> pass-by-reference and varlena.
>
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
<http://www.commandprompt.com/>
> PostgreSQL Replication, Consulting, Custom Development, 24x7 sup****t
>

------=_Part_12102_31109090.1210205686552
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: quoted-printable
Content-Disposition: inline

<div>If I make it pass-by-reference and varlena do I have to worry about
TO=
ASTing and deTOASTing everying in my INPUT and OUTPUT functions? </div>
<div><br>&nbsp;</div>
<div class=3D"gmail_quote">On Wed, May 7, 2008 at 5:15 PM, Alvaro Herrera
&=
lt;<a
href=3D"mailto:alvherre@[EMAIL PROTECTED]
">alvherre@[EMAIL PROTECTED]
>&gt; wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"PADDING-LEFT: 1ex; MARGIN: 0px
0=
px 0px 0.8ex; BORDER-LEFT: #ccc 1px solid">Toby Chavez escribi=F3:<br>
<div class=3D"Ih2E3d"><br>&gt; My custom type needs to have one biginteger
=
and one text value... pretty<br>&gt; straight forward. I guess my first
que=
stion is if there are any examples out<br>&gt; there that do something
simi=
lar. I have looked extensively through the<br>
&gt; contrib directory and can&#39;t find anything very helpful. If not,
co=
uld<br>&gt; someone help me understand what my c struct would look like
and=
 what values<br>&gt; I need for INTERNALLENGTH, ALIGNMENT, STORAGE, etc in
=
the CREATE TYPE<br>
&gt; command?<br><br></div>Probably what&#39;s biting you is that the type
=
needs to be<br>pass-by-reference and varlena.<br><font
color=3D"#888888"><b=
r>--<br>Alvaro Herrera &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
&nb=
sp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;<a
href=3D"http:=
//www.commandprompt.com/"
target=3D"_blank">http://www.CommandPrompt.com/</=
a><br>
PostgreSQL Replication, Consulting, Custom Development, 24x7
sup****t<br></f=
ont></blockquote></div><br>

------=_Part_12102_31109090.1210205686552--