comparing varchar fields in PL/pgSQL

From: Peter Dimov <jquest_j(at)yahoo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: comparing varchar fields in PL/pgSQL
Date: 2002-06-15 10:41:04
Message-ID: 20020615104104.30902.qmail@web21505.mail.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message ktt 2002-06-15 11:48:15 inserting into multiple tables
Previous Message Mike Mascari 2002-06-15 10:28:03 Re: Possible feature