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 92CCD921B4A for ; Fri, 30 May 2003 11:03:02 -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 15477-04 for ; Fri, 30 May 2003 11:03:01 -0400 (EDT) Received: from localhost.localdomain (unknown [65.217.53.66]) by developer.postgresql.org (Postfix) with ESMTP id AAC72921B49 for ; Fri, 30 May 2003 11:03:01 -0400 (EDT) Received: from thorn.mmrd.com (thorn.mmrd.com [172.25.10.100]) by localhost.localdomain (8.12.8/8.12.8) with ESMTP id h4UFrPM3003989; Fri, 30 May 2003 11:53:26 -0400 Received: from gnvex001.mmrd.com (gnvex001.mmrd.com [192.168.3.55]) by thorn.mmrd.com (8.11.6/8.11.6) with ESMTP id h4UF2wL01870; Fri, 30 May 2003 11:02:58 -0400 Received: from camel.mmrd.com ([172.25.5.213]) by gnvex001.mmrd.com with SMTP (Microsoft Exchange Internet Mail Service Version 5.5.2653.13) id 2YCP5859; Fri, 30 May 2003 11:02:56 -0400 Subject: Re: Please Help me ???? From: Robert Treat To: utomo restu Cc: pgsql-admin@postgresql.org In-Reply-To: <20030530040825.10531.qmail@linuxmail.org> References: <20030530040825.10531.qmail@linuxmail.org> Content-Type: text/plain Content-Transfer-Encoding: 7bit X-Mailer: Ximian Evolution 1.0.8 Date: 30 May 2003 11:02:58 -0400 Message-Id: <1054306978.2206.3518.camel@camel> Mime-Version: 1.0 X-Virus-Scanned: by amavisd-new X-Archive-Number: 200305/418 X-Sequence-Number: 8980 First, make sure your running on a version of 7.3, then check out the following docs: http://techdocs.postgresql.org/guides/SetReturningFunctions http://www.gtsm.com/cgi/psearch?page=plpgsql.html;q=plpgsql;j=0;c=0;h=0 Robert Treat On Fri, 2003-05-30 at 00:08, utomo restu wrote: > > 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 > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly