Received: from sss.sss.pgh.pa.us (sss.pgh.pa.us [209.114.166.2]) by hub.org (8.9.3/8.9.3) with ESMTP id TAA88032 for ; Wed, 29 Sep 1999 19:25:35 -0400 (EDT) (envelope-from tgl@sss.pgh.pa.us) Received: from sss.sss.pgh.pa.us (localhost [127.0.0.1]) by sss.sss.pgh.pa.us (8.9.1/8.9.1) with ESMTP id TAA05301; Wed, 29 Sep 1999 19:24:26 -0400 (EDT) To: "Ismail Kizir" cc: pgsql-sql@postgreSQL.org Subject: Re: [SQL] Date: Wed, 29 Sep 1999 23:49:15 +0300 In-reply-to: Your message of Wed, 29 Sep 1999 16:36:56 -0400 (EDT) <014801bf0abc$184ea580$a300aec3@kaplan> Date: Wed, 29 Sep 1999 19:24:26 -0400 Message-ID: <5299.938647466@sss.pgh.pa.us> From: Tom Lane "Ismail Kizir" writes: > I tried to code the example below but it responded with error message > something like '$= operator not defined for types int4 and float8 ...' That's a known bug in plpgsql. You can work around it by putting spaces acround the '=' operator (you may need them around other operators too). I assume it'll get fixed properly for 6.6... regards, tom lane