comparing varchar fields in PL/pgSQL - Mailing list pgsql-general

From Peter Dimov
Subject comparing varchar fields in PL/pgSQL
Date
Msg-id 20020615104104.30902.qmail@web21505.mail.yahoo.com
Whole thread Raw
List pgsql-general

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

pgsql-general by date:

Previous
From: Mike Mascari
Date:
Subject: Re: Possible feature
Next
From: ktt
Date:
Subject: inserting into multiple tables