Call to build-in operator from new operator
Greetings,
I don't really know if this is the correct place to ask this question, if
not please direct me to the correct mailing list.
I'm trying to develop a new operator for PostGreSQL (actually for
TelegraphCQ, which is an extension of PSQL). Part of the operator's
procedure is the @-operator. So now my question is: How do I call the on_pb
function from inside my own function?.
The on_pb of course takes the argument 'PG_FUNCTION_ARGS' which is defined
in fmgr.h as 'FunctionCallInfo fcinfo' which is defined as pointer to
'struct FunctionCallInfoData', so my question boils down to:
What do I put into this struct to call 'on_pb' with two arguments from the
call to my function?
Further, is there a way to access data in tables in the database other than
those given as arguments to the function? And how?
Sincerely
Kim Bille
Department of Computer Science
Aalborg University
Denmark
--
"Mind are like parachutes --- they only work when open"
As others pointed out, DirectFunctionCall2 is your friend. There is a
mailing list for TelegraphCQ. It's a Yahoo group - visit
http://groups.yahoo.com/group/telegraphcq
About accessing data from a table in another database ... we need to
know more about what exactly you're doing. Please post on the tcq
mailing list.
--
Pip-pip
Sailesh
http://www.cs.berkeley.edu/~sailesh
Use the DirecFunctionCall1, DirecFunctionCall2, etc. functions.
... John
Show quoted text
-----Original Message-----
From: pgsql-hackers-owner@postgresql.org
[mailto:pgsql-hackers-owner@postgresql.org] On Behalf Of kim@billes.dk
Sent: Monday, April 18, 2005 10:40 PM
To: pgsql-hackers@postgresql.org
Subject: [HACKERS] Call to build-in operator from new operatorGreetings,
I don't really know if this is the correct place to ask this
question, if not please direct me to the correct mailing list.I'm trying to develop a new operator for PostGreSQL (actually
for TelegraphCQ, which is an extension of PSQL). Part of the
operator's procedure is the @-operator. So now my question
is: How do I call the on_pb function from inside my own function?.
The on_pb of course takes the argument 'PG_FUNCTION_ARGS'
which is defined in fmgr.h as 'FunctionCallInfo fcinfo' which
is defined as pointer to 'struct FunctionCallInfoData', so my
question boils down to:What do I put into this struct to call 'on_pb' with two
arguments from the call to my function?Further, is there a way to access data in tables in the
database other than those given as arguments to the function? And how?Sincerely
Kim Bille
Department of Computer Science
Aalborg University
Denmark--
"Mind are like parachutes --- they only work when open"---------------------------(end of
broadcast)---------------------------
TIP 6: Have you searched our list archives?
Import Notes
Resolved by subject fallback