Received: from finch-post-11.mail.demon.net (finch-post-11.mail.demon.net [194.217.242.39]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f6IGXYa39879 for ; Wed, 18 Jul 2001 12:33:34 -0400 (EDT) (envelope-from dev@archonet.com) Received: from mwynhau.demon.co.uk ([193.237.186.96] helo=mainbox.archonet.com) by finch-post-11.mail.demon.net with esmtp (Exim 2.12 #1) id 15MuGP-000M7w-0B; Wed, 18 Jul 2001 16:33:30 +0000 Received: from client (client.archonet.com [192.168.1.16]) by mainbox.archonet.com (Postfix) with SMTP id 2167412B2D; Wed, 18 Jul 2001 17:24:32 +0100 (BST) Message-ID: <002301c10fa6$1f176820$1001a8c0@archonet.com> From: "Richard Huxton" To: "Gary Stainburn" , "pgsql-sql" References: <01071815102309.11978@gary.ringways.co.uk> <0107181624100B.11978@gary.ringways.co.uk> Subject: Re: pl/pgsql - code review + question Date: Wed, 18 Jul 2001 17:24:27 +0100 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 5.50.4133.2400 X-MIMEOLE: Produced By Microsoft MimeOLE V5.50.4133.2400 X-Archive-Number: 200107/250 X-Sequence-Number: 4047 From: "Gary Stainburn" > My problem now is that when I include the code to handle the record not being > there, from the pgsql chapter (section 23.2.3.3) I get the following errors Hey - stop that! If everyone starts reading the docs and quoting chapter refs all we'll be left with are *difficult* questions ;-) > based of the function below. Can anyone explain why the concat of the string > is failing. If I simply "raise exception ''member not found''" all works fine. Yep - this one keeps getting me too. > raise exception ''Member '' || unitno || '' not found''; RAISE EXCEPTION ''Member % not found'', unitno; Don't know why the parser for RAISE doesn't like string concat. Possibly because it maps to the elog() error-reporting function underneath. - Richard Huxton