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 [EMAIL PROTECTED] so that your > message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org
