From: scott.marlowe <scott.marlowe@ihs.com>
To: utomo restu <utomo@linuxmail.org>
Cc: pgsql-php@postgresql.org
Cc: pgsql-general@postgresql.org
Subject: Re: [PHP] help ?
Date: Fri, 30 May 2003 08:47:27 -0600 (MDT)
Message-ID: <Pine.LNX.4.33.0305300839420.31323-100000@css120.ihs.com> (raw)
In-Reply-To: <20030530050017.15862.qmail@linuxmail.org>
The PHP list is probably sub-optimal, so I'm cross posting this to
general. Whoever gets it next there, please remove the PHP cc then.
On Fri, 30 May 2003, 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.
Every version I've ever used. If you are running anything older than
7.2.4 you should upgrade.
7.3.3 is the latest stable release, and it is quite stable and very fast.
> 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) ?
You're going to need 7.3.x to do this, so you may as well upgrade to it
now. Record sets can be returned as of version 7.3.
For more information on record sets in stored procedures, see the
programmer's guide:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=programmer.html
Sepcifically the section on returning rows in plpgsql:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=0&file=plpgsql-control-structures.h...
Happy hacking!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-php@postgresql.org
Cc: scott.marlowe@ihs.com, utomo@linuxmail.org, pgsql-general@postgresql.org
Subject: Re: [PHP] help ?
In-Reply-To: <Pine.LNX.4.33.0305300839420.31323-100000@css120.ihs.com>
References: <20030530050017.15862.qmail@linuxmail.org> <Pine.LNX.4.33.0305300839420.31323-100000@css120.ihs.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox