Received: from localhost (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 8AA9B475D39 for ; Fri, 13 Sep 2002 06:41:37 -0400 (EDT) Received: from mail.gmx.net (mail.gmx.net [213.165.64.20]) by postgresql.org (Postfix) with SMTP id 27C07475C26 for ; Fri, 13 Sep 2002 06:41:36 -0400 (EDT) Received: (qmail 26868 invoked by uid 0); 13 Sep 2002 10:41:38 -0000 Received: from chello062178186201.1.15.tuwien.teleweb.at (HELO beeblebrox) (62.178.186.201) by mail.gmx.net (mp018-rz3) with SMTP; 13 Sep 2002 10:41:38 -0000 Message-ID: <007301c25b12$5b8d96e0$4201a8c0@beeblebrox> From: "Michael Paesold" To: References: Subject: Assignments in PL/pgSQL Date: Fri, 13 Sep 2002 12:43:10 +0200 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 X-Virus-Scanned: by AMaViS new-20020517 X-Archive-Number: 200209/131 X-Sequence-Number: 9408 Hi all, although this is not really SQL, but PL/pgSQL, I hope this is the right place to ask. I have written a complex triggers. It works very well. Just now I have realized that I have used the = operater for variable assignments, instead of the := operater. To my suprise, there was no error or warning, and the store procedure works very well! e.g. NEW.someval = rec.someother; works as well as NEW.someval := rec.someother; Can you confirm that both are valid? Can someone explain this? And is it safe to use the former syntax? Best Regards, Michael Paesold