By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,178 Members | 971 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,178 IT Pros & Developers. It's quick & easy.

Linking question

P: n/a
Hi,

I want to make use of some contrib/dblink functions inside my user
defined functions, e.g. I would like to be able to call dblink_record()
from my user defined code in this way:

dblink_record("param1","param2");

Is this possible?

I would like to avoid:

1) inserting all the dblink code in my *.c file. This would not be a
very clean way.

2) executing: "select dblink(...)"

Any ideas on how to link my user-defined function with functions in
another file? This is maybe a C question but I'm not good at it at all!
Thanks in advance!!
Ntinos
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org

Nov 23 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Thu, Oct 21, 2004 at 09:26:30AM +0300, Katsaros Kwn/nos wrote:

I want to make use of some contrib/dblink functions inside my user
defined functions, e.g. I would like to be able to call dblink_record()
from my user defined code in this way:

dblink_record("param1","param2");

Is this possible?

I would like to avoid:

1) inserting all the dblink code in my *.c file. This would not be a
very clean way.

2) executing: "select dblink(...)"


Why do you want to avoid "select dblink(...)"? It would be easy
to handle such a query with the Server Programming Interface (SPI):

http://www.postgresql.org/docs/7.4/static/spi.html

If you don't use SPI then you're probably going to have to duplicate
some of the magic it performs. This seems needless, especially
since you admit that you're not good at C.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.