Received: from sss.pgh.pa.us (sss.pgh.pa.us [209.114.132.154]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id f2IKbjx63400 for ; Sun, 18 Mar 2001 15:37:45 -0500 (EST) (envelope-from tgl@sss.pgh.pa.us) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.11.1/8.11.1) with ESMTP id f2IKbgt25644; Sun, 18 Mar 2001 15:37:42 -0500 (EST) To: jreniz cc: pgsql-hackers@postgreSQL.org Subject: Re: Trigger problem In-reply-to: <3AB2F4A4.41255255@tutopia.com> References: <3AB2F4A4.41255255@tutopia.com> Comments: In-reply-to jreniz message dated "Sat, 17 Mar 2001 00:22:44 -0500" Date: Sun, 18 Mar 2001 15:37:41 -0500 Message-ID: <25641.984947861@sss.pgh.pa.us> From: Tom Lane X-Archive-Number: 200103/782 X-Sequence-Number: 6115 jreniz writes: > So, when I run this trigger there is a mistake: > ''there is no operator '=$' for types 'int4' and 'int4' > (My system is 6.5.3) This is an old bug. Update to 7.0.3. It might work to add spaces around the '=' signs in your trigger function, but an update would be a good idea anyway. regards, tom lane