Thread: Inquiry From Form [pgsql]

Hi,
I have one problem.When I have defined trigger before update on some table, then update was succesfully performed but
updatedvalue haven\'t changed, his value is old!This effect has been althrough trigger function do not perform any
operation.If I drop trigger before update, then update was performed OK! Why? Where is the problem? 
Help. Thanks

On Thu, 28 Nov 2002, Richard Lukacik wrote:

> I have one problem.When I have defined trigger before update on some
> table, then update was succesfully performed but updated value
> haven\'t changed, his value is old!This effect has been althrough
> trigger function do not perform any operation. If I drop trigger
> before update, then update was performed OK! Why? Where is the
> problem?

You haven't sent the trigger, so it's hard to say, but I'd guess that
you might be returning either OLD or NULL from the trigger.