Re: help with a stored procedure - Mailing list pgsql-general

From Michael Fuhr
Subject Re: help with a stored procedure
Date
Msg-id 20050103173543.GA58846@winnie.fuhr.org
Whole thread Raw
In response to help with a stored procedure  ("Jason Tesser" <JTesser@nbbc.edu>)
List pgsql-general
On Mon, Jan 03, 2005 at 08:29:18AM -0600, Jason Tesser wrote:

> I am new to postgres stored procedures and would like a little help.  My
> function basically takes 2 arguments and inserts data into a table from
> a select statement.  I want it to return the number of records inserted.

See "Obtaining the Result Status" in the "Basic Statements" section
of the PL/pgSQL documentation.

--
Michael Fuhr
http://www.fuhr.org/~mfuhr/

pgsql-general by date:

Previous
From: Pierre-Frédéric Caillaud
Date:
Subject: Re: Generating unique values for TEXT columns
Next
From: Bruce Momjian
Date:
Subject: Re: PostgreSQL 8.0.0 Release Candidate 3