X-Original-To: pgsql-admin@postgresql.org Received: from localhost (developer.postgresql.org [64.117.224.193]) by developer.postgresql.org (Postfix) with ESMTP id 787C892333F for ; Fri, 30 May 2003 00:08:47 -0400 (EDT) Received: from developer.postgresql.org ([64.117.224.193]) by localhost (developer.postgresql.org [64.117.224.193:10024]) (amavisd-new) with ESMTP id 66221-10 for ; Fri, 30 May 2003 00:08:46 -0400 (EDT) Received: from spf1.us.outblaze.com (205-158-62-158.outblaze.com [205.158.62.158]) by developer.postgresql.org (Postfix) with SMTP id 758C59232EF for ; Fri, 30 May 2003 00:08:45 -0400 (EDT) Received: (qmail 14819 invoked from network); 30 May 2003 04:08:44 -0000 Received: from unknown (205.158.62.68) by spf1.us.outblaze.com with QMQP; 30 May 2003 04:08:44 -0000 Received: (qmail 93554 invoked from network); 30 May 2003 04:08:28 -0000 Received: from unknown (HELO ws5-2.us4.outblaze.com) (205.158.62.132) by 205-158-62-153.outblaze.com with SMTP; 30 May 2003 04:08:26 -0000 Received: (qmail 10532 invoked by uid 1001); 30 May 2003 04:08:25 -0000 Message-ID: <20030530040825.10531.qmail@linuxmail.org> Content-Type: text/plain; charset="iso-8859-1" Content-Disposition: inline Content-Transfer-Encoding: 7bit MIME-Version: 1.0 X-Mailer: MIME-tools 5.41 (Entity 5.404) Received: from [203.130.216.210] by ws5-2.us4.outblaze.com with http for utomo@linuxmail.org; Fri, 30 May 2003 12:08:25 +0800 From: "utomo restu" To: pgsql-admin@postgresql.org Date: Fri, 30 May 2003 12:08:25 +0800 Subject: Please Help me ???? X-Originating-Ip: 203.130.216.210 X-Originating-Server: ws5-2.us4.outblaze.com X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/410 X-Sequence-Number: 8972 Dear All I'am a new user in postgresql, i want to ask about : 1. The one who is intended with STORED PROCEDURE, how its implement and what its surplus. Version POSTGRESQL that how much possess STRORED PROCEDURE. 2. In when I make the function as follows: CREATE FUNCTION forward(CHAR(10)) RETURNS CHAR(10), CHAR(30) AS 'select no_id, name FROM address where no_id=$1;' Language 'sql'; To step forward orders the error ... Which wants I asked, how make a function that can step forward RETURNS More than a column (I want to show 2 columns i.e. no_id and Name) ? thank's -- ______________________________________________ http://www.linuxmail.org/ Now with e-mail forwarding for only US$5.95/yr Powered by Outblaze