hi there!

I'm new at PSQL and i'm having some issues, so i'd appreciate any help or
advice...

here's the deal: i made a stored procedure that selects a huge amount of
info from a lot of tables and uses "suspend". it works, the result set
shows columns with all the infos i wanted.
My real aim is to have a trigger that calls this SP when anything happens
at a certain table, and i'm having some problems with that.

How do i call a SP from inside a trigger? I tried "select * from
<storedprocedure>", but it doesn't work...

thanks in advance



--
Thamiris Monteiro - Software Scravo
www.scravo.com.br

Fone: +55 (41) 3014.3028
Fax: +55 (41) 3026.3028


[Non-text portions of this message have been removed]