X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A6873D1B273 for ; Thu, 10 Jun 2004 12:39:15 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 91415-03 for ; Thu, 10 Jun 2004 15:39:09 +0000 (GMT) Received: from anchor-post-35.mail.demon.net (anchor-post-35.mail.demon.net [194.217.242.85]) by svr1.postgresql.org (Postfix) with ESMTP id 5AF28D1B387 for ; Thu, 10 Jun 2004 12:39:06 -0300 (ADT) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by anchor-post-35.mail.demon.net with esmtp (Exim 3.35 #1) id 1BYRdv-00050M-0Z; Thu, 10 Jun 2004 16:39:05 +0100 Received: from [192.168.1.17] (client17.archonet.com [192.168.1.17]) by mainbox.archonet.com (Postfix) with ESMTP id 7435A1781B; Thu, 10 Jun 2004 16:38:41 +0100 (BST) Message-ID: <40C88082.2070307@archonet.com> Date: Thu, 10 Jun 2004 16:38:42 +0100 From: Richard Huxton User-Agent: Mozilla Thunderbird 0.6 (X11/20040502) X-Accept-Language: en-us, en MIME-Version: 1.0 To: mlong@datalong.com Cc: pgsql-sql@postgresql.org Subject: Re: Function returns error References: <37936EEC582B394A9E1AA951991A551604C3C0@dev001_pdc.Dev.cadcorp.net> <20040610160627.B1308@hermes.hilbert.loc> <49717.161.88.255.139.1086879689.squirrel@datalong.com> In-Reply-To: <49717.161.88.255.139.1086879689.squirrel@datalong.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.0 tagged_above=0.0 required=5.0 tests= X-Spam-Level: X-Archive-Number: 200406/89 X-Sequence-Number: 18034 Michael Long wrote: > ERROR: operator does not exist: character varying == "unknown" > HINT: No operator matches the given name and argument type(s). You may need to add > explicit type casts. > CONTEXT: PL/pgSQL function "building_insert" line 14 at if Common mistake, still make it myself on occasion. The '==' operator doesn't exist in plpgsql, you should use '=' when comparing and ':=' for assignment. HTH -- Richard Huxton Archonet Ltd