X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id D3516475FC8 for ; Wed, 23 Apr 2003 04:52:52 -0400 (EDT) Received: from mail1.tpgi.com.au (mail.tpgi.com.au [203.12.160.57]) by postgresql.org (Postfix) with ESMTP id A085147631F for ; Wed, 23 Apr 2003 04:52:47 -0400 (EDT) Received: from jac (free-tpg-213.tpgi.com.au [203.219.31.213] (may be forged)) by mail1.tpgi.com.au (8.11.6/8.11.6) with SMTP id h3N8qlS01434 for ; Wed, 23 Apr 2003 18:52:48 +1000 Message-ID: <000b01c30975$b71d4c00$1400a8c0@jac> From: "jack" To: Subject: is there a special function like the format on raise notice Date: Wed, 23 Apr 2003 18:52:46 +1000 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.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 X-Spam-Status: No, hits=-1.6 required=5.0 tests=BAYES_30 version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/321 X-Sequence-Number: 13022 Hi, all With pl/sql, is there a special function such as s1 := function(''invalid code: %'',iErrCode); s1 becomes ''invalid code: 120'' Thank you Jack