Re: help with a stored procedure

From: Michael Fuhr <mike(at)fuhr(dot)org>
To: Jason Tesser <JTesser(at)nbbc(dot)edu>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: help with a stored procedure
Date: 2005-01-03 17:35:43
Message-ID: 20050103173543.GA58846@winnie.fuhr.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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/

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2005-01-03 17:36:19 Re: PostgreSQL 8.0.0 Release Candidate 3
Previous Message Pierre-Frédéric Caillaud 2005-01-03 17:25:50 Re: Generating unique values for TEXT columns