From: | "Seung Hyun Jeong" <jeongs(at)cs(dot)man(dot)ac(dot)uk> |
---|---|
To: | <pgsql-hackers(at)postgresql(dot)org> |
Subject: | about call-convention in PostgreSQL programming |
Date: | 2001-11-21 13:19:39 |
Message-ID: | 002101c1728f$2c83f5e0$15c65882@cs.man.ac.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
I am learning PostgreSQL programming, but it is still so difficult.
Let me ask some of you who have better experience than me- in fact, I am a
novice!
I am trying to access index structure by using user-defined functions, and
as the first step,
I wrote the following simple user-defined functions.
PG_FUNCTION_INFO_V1(open_gist);
PG_FUNCTION_INFO_V1(close_gist);
/***************************************************************************
/
Relation open_gist(PG_FUNCTION_ARGS)
{
char *index_name = (char *) PG_GETARG_POINTER(0);
elog(NOTICE, "%s\n", index_name);
return index_openr(index_name);
}
/***************************************************************************
/
void close_gist(PG_FUNCTION_ARGS)
{
Relation index_relation = (Relation) PG_GETARG_POINTER(0);
index_close(index_relation);
}
The problem is that I cannot understand the PostgreSQL's call-convention,
though I have go through
the header file "fmgr.h".
I tried to follow some examples as above, but it won't work.
I just got a garbage string on screen printed by elog(), when I execute
"select open_gist('myindex');".
So, I tried to pass index name directly to index_openr(), that is
index_openr("myindex"), then there was no problem.
I think it is the problem about how to pass arguments.
And do you think I can execute the above functions like this:
select close_gist(open_gist('myindex'));
My question is whether the return data from open_gist() can be passed to
close_gist() or not.
I mean, because data type "Relation" is just internal data type, not the
base data type of PostgreSQL,
I am worried about the representation of return data type.
Do I need to register "Relation" as user-defined data type as well?
(When I create the two functions, I declared input and output data types to
be "opaque".)
Could you advise me anything about that?
Cheers.
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Lockhart | 2001-11-21 13:27:45 | Re: broken time operator? |
Previous Message | Patrick Welche | 2001-11-21 12:58:37 | Re: RULES |