Message-ID: <412CA074.2000606@netcabo.pt>
Date: Wed, 25 Aug 2004 15:21:40 +0100
From: "Pedro B." <pedro.borracha@netcabo.pt>
User-Agent: Mozilla Thunderbird 0.7.3 (Windows/20040803)
MIME-Version: 1.0
To: pgsql-sql@postgresql.org
Subject: PQexec and SPI_exec
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Hello everyone.

I'm experiencing some doubts regarding a procedure i have (.c compiled 
as .so) running as an 'after insert for each row' trigger.

This trigger is supposed to do a simple query, something like
SELECT * FROM table order by id where processed=0 limit 1

It's not the perfect way to get the vars of the insert itself, but the 
result is a set of 45 columns, and the operations of the trigger are 
somehow complex, so .c is really a necessity on this one, and as long as 
this select actually returns the proper values, i can deal with it later.

But my problem is not one of a structure nature: my problem is the fact 
that using SPI_exec, and the SPI_getvalue(SPI_tuptable->vals[0], 
SPI_tuptable->tupdesc, columnX), and 
DatumGetInt32(DirectFunctionCall1(int4in, 
CStringGetDatum(SPI_getvalue(SPI_tuptable->vals[0], 
SPI_tuptable->tupdesc, columnX)))), etc, it all works fine.
the SPI-running-from-the-triggered-.so can detect the correct values - 
from the insert that triggered it.

I would prefer to use the more friendly PQexec and the simpler 
PQgetvalue(res,0,X), but this last approach does not return the values 
of the insert that triggered it. It returns the values from the "the 
last insert before this one". What is the proper way to make this method 
work?

I'm sorry if this might be a basic question, but i have tried so many 
things, that i'm probably too puzzled right now to make any sense.

Any help is deeply appreciated.

Thanks,
\\Pedro