On 08/29/2012 09:18 PM, tamanna madaan wrote:
1. what are the ways to get the value returned by this library function .
You need to wrap the C library function with a PostgreSQL C extension that uses the fmgr.h APIs, so it's callable from SQL and can return a result to SQL. See:
http://www.postgresql.org/docs/current/static/xfunc-c.html
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.
The call will return when the C wrapper function returns, so they'll be executed in series not in parallel.
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.
The calls will be executed in the order they appear in the PL/PgSQL function.
-- Craig Ringer -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general