comparing varchar fields in PL/pgSQL

Started by Peter Dimovalmost 24 years ago1 messagesgeneral
Jump to latest
#1Peter Dimov
jquest_j@yahoo.com

Hi all,

I try to make a simple triger with PL/pgSQL.

It starts on update and in my table I have a field mname varchar(20).

How can I compare if the new and the old value for this field are the same.

I tryed: if NEW.mname <> OLD.mNAME THEN ....

but it is not working !

Exist any deteilet documentation about the PL/pgSQL.

Many thanks.

---------------------------------
Do You Yahoo!?
Sign-up for Video Highlights of 2002 FIFA World Cup