Обсуждение: Store Procedures

Hello.
I been having "problems" with and application, and i want to store in
the data base the changes(update) made to a specific table.
what i need is to see how 2 fields specific change there values, to do
that i plan to make a temporal table with the fields before and after
plus the time the changes where made... can i do this with store
procedures??

here are the 2 fields are:
"cajas" INTEGER,
"unidades" INTEGER,

in the temporal table will be
"before_cajas" INTEGER,
"before_unidades" INTEGER,
"after_cajas" INTEGER,
"after_unidades" INTEGER,

Regards Cesar Alvarez.

> what i need is to see how 2 fields specific change there values, to do
> that i plan to make a temporal table with the fields before and after
> plus the time the changes where made... can i do this with store
> procedures??

http://www.varlena.com/varlena/GeneralBits/104.php

Check out this discussion on this link.  It is very similar to what you want to do.  If fact, my
experience is that "generalbits" is an excellent cookbook for and learning Postgresql developer.

Regards,
Richard Broersma Jr.

Richard Broersma Jr wrote:

what i need is to see how 2 fields specific change there values, to do 
that i plan to make a temporal table with the fields before and after 
plus the time the changes where made... can i do this with store 
procedures??   

http://www.varlena.com/varlena/GeneralBits/104.php

Check out this discussion on this link.  It is very similar to what you want to do.  If fact, my
experience is that "generalbits" is an excellent cookbook for and learning Postgresql developer.

Regards,
Richard Broersma Jr.
 

thanks
i think this helps me a lot, im gona play with the triggers and all that.

Cesar Alvarez
Web Development Asesor and Software Enginner.