Hello see http://www.postgresql.org/docs/9.1/static/xfunc-c.html plpgsql can call any sql function, so you have to register your C function as custom postgresql sql function Regards Pavel Stehule 2012/8/29 tamanna madaan <tamanna.madaan@xxxxxxxxxxxxxxx>: > Hi All > > I have created a function in C language . This is to be called from a pgsql > function . > Let say the C language function name is "test1" and pgsql function name is > "test" . > > test1 is called from test three times with different arguments . For > example : > > test () > begin > > test1(arg1); --test1 is a C library function returning an int > test1(arg2); > test1(arg3); > > end; > > Now, my questions are : > > 1. what are the ways to get the value returned by this library function . > 2. when test1 is called, will it wait for "test1" to return before > continuing with the next statement in "test" or it will continue with the > next statement parallely while "test1" is being executed. > 3. Moreover, will test1 be called sequentially in order for all the three > arguments i.e arg1 first and arg3 in last. Or there can be a different > order. > > Thanks.. > Tamanna > > > > > > > > > -- > > Tamanna | Associate Consultant > GlobalLogic Inc. | Innovation by Design > ARGENTINA | CHILE | CHINA | INDIA | ISRAEL | UKRAINE | UK | USA > Office: 0120-4062000 x 2971 > www.globallogic.com > > http://www.globallogic.com/email_disclaimer.txt > -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
