making data types - Mailing list pgsql-interfaces

From Lonnie Cumberland
Subject making data types
Date
Msg-id 20010416122117.82328.qmail@web12501.mail.yahoo.com
Whole thread Raw
Responses Re: making data types  (selkovjr@mcs.anl.gov)
List pgsql-interfaces
Hello All,

Well, things are starting to make sense and come together slowly as I keep
getting a better feel for using PostgreSQL and the extension interfacing in
"C". 
I am now wondering if someone could please explain to me how to make a new data
type that I can use in my "C" functions and return to the calling PL/pgSQL
function.

for example in "C" I might have something like:

typedef struct dataset 
{    char one[20];    char two[30];
} dataset;


then I could easily have:

dataset *work_on_data_set(text *invalue1, int4 invalue2)
{    dataset *somedataset;
.
.
.    return somedataset;
}

My question is how to declare "dataset" so that both the "C" and PL/pgSQL can
see the same structure (type)?

Can anyone please clear this up?

Lonnie



__________________________________________________
Do You Yahoo!?
Get email at your own domain with Yahoo! Mail. 
http://personal.mail.yahoo.com/


pgsql-interfaces by date:

Previous
From: Lonnie Cumberland
Date:
Subject: retrieving multiple results?
Next
From: Peter Eisentraut
Date:
Subject: Re: Now for the VARDATA, VARSIZE, and VARHDRSZ stuff