Received: from web12501.mail.yahoo.com (web12501.mail.yahoo.com
	[216.136.173.193])
	by postgresql.org (8.11.3/8.11.1) with SMTP id f3GCLKu00374
	for <pgsql-interfaces@postgresql.org>;
	Mon, 16 Apr 2001 08:21:21 -0400 (EDT)
	(envelope-from lonnie_cumberland@yahoo.com)
Message-ID: <20010416122117.82328.qmail@web12501.mail.yahoo.com>
Received: from [141.217.140.65] by web12501.mail.yahoo.com;
	Mon, 16 Apr 2001 05:21:17 PDT
Date: Mon, 16 Apr 2001 05:21:17 -0700 (PDT)
From: Lonnie Cumberland <lonnie_cumberland@yahoo.com>
Subject: making data types
To: pgsql-interfaces@postgresql.org
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
X-Archive-Number: 200104/56
X-Sequence-Number: 1439

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/