calling a c function from a stored
prcedure, but then I am concerned with degradation in performance since
this particular function would be handling a large amount of requests a
second. Additionally, I would like to maintain continuity in the code
and do not want to introduce another
I would like to know if there is a way to return nTuples for a cursor
without having to FETCH ALL from the cursor. I am sorting over 500k
records and growing.. and return 1k at time from the cursor. But, It I
also need to obtain the total number of records in the cursor without
having to eit
I wrote a plpgsql function/stored procedure to get around this problem.
I am not sure specifically what information you need about the row
after INSERT, but you could write a function that performs the INSERTs
and summing. After the initial INSERT you can use a SELECT INTO
statement to pass
