making data types

From: Lonnie Cumberland <lonnie_cumberland(at)yahoo(dot)com>
To: pgsql-interfaces(at)postgresql(dot)org
Subject: making data types
Date: 2001-04-16 12:21:17
Message-ID: 20010416122117.82328.qmail@web12501.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Peter Eisentraut 2001-04-16 14:03:54 Re: Now for the VARDATA, VARSIZE, and VARHDRSZ stuff
Previous Message Avinash K.G 2001-04-16 08:26:48