Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Pgsql General > Re: Custom Base...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 2 of 9 Topic 15486 of 17437
Post > Topic >>

Re: Custom Base Type in C

by david.t.wilson@[EMAIL PROTECTED] ("David Wilson") May 7, 2008 at 07:12 PM

On Wed, May 7, 2008 at 7:06 PM, Toby Chavez <odnamr@[EMAIL PROTECTED]
> wrote:

> My custom type needs to have one biginteger and one text value... pretty
> straight forward. I guess my first question is if there are any examples
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?

Is there any particular reason why this needs to be done in C? Why not
just create the type normally as per:

CREATE TYPE my_transition_type AS (a bigint, b text);

And then create your aggregate function using that type?

I can't help you with the C stuff, but you may be making far more work
for yourself than you really need.

-- 
- David T. Wilson
david.t.wilson@[EMAIL PROTECTED]
 
Sent via pgsql-general mailing list (pgsql-general@[EMAIL PROTECTED]
)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
 




 9 Posts in Topic:
Custom Base Type in C
odnamr@[EMAIL PROTECTED]   2008-05-07 17:06:40 
Re: Custom Base Type in C
david.t.wilson@[EMAIL PRO  2008-05-07 19:12:56 
Re: Custom Base Type in C
alvherre@[EMAIL PROTECTED  2008-05-07 19:15:10 
Using a composite SQL type in C
heron@[EMAIL PROTECTED]   2008-05-07 17:29:32 
Re: Custom Base Type in C
odnamr@[EMAIL PROTECTED]   2008-05-07 18:02:29 
Re: Custom Base Type in C
odnamr@[EMAIL PROTECTED]   2008-05-07 18:14:46 
Re: Custom Base Type in C
dim@[EMAIL PROTECTED] (D  2008-05-08 14:03:39 
Re: Using a composite SQL type in C
odnamr@[EMAIL PROTECTED]   2008-05-08 11:11:26 
Re: Using a composite SQL type in C
heron@[EMAIL PROTECTED]   2008-05-08 11:20:07 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Sat Nov 22 11:58:30 CST 2008.