Re: [SQL] Complete instruction in a trigger

2005-01-27 Thread Tom Lane
Wilton <[EMAIL PROTECTED]> writes: > I have a table "customers", then a user go there and change the customer > record, for example he changes the zip code column. Then I can know that > something changed into the "customer table", and send a full update of > that record through the web to the d

Re: [SQL] Complete instruction in a trigger

2005-01-27 Thread Wilton
Sorry if i´m sendind this question to the wrong place... it´s because i´m new here and i didn´t found the place in the web to send my question over the same that i already did. But let´s see if you can help me. The situation is like this. I have a table "customers", then a user go there and

Re: [SQL] Complete instruction in a trigger

2005-01-27 Thread Richard Huxton
Wilton wrote: Hi... People, i wanna know how can i know inside of a function whar the trigger called, i mean which instruction SQL it called. I do not wanna know if it´s a insert, update or delete (tp_op), i need to know the complete instruction. For example, i need to know something like this:

[SQL] Complete instruction in a trigger

2005-01-27 Thread Wilton
Hi... People, i wanna know how can i know inside of a function whar the trigger called, i mean which instruction SQL it called. I do not wanna know if it´s a insert, update or delete (tp_op), i need to know the complete instruction. For example, i need to know something like this: update phones