Re: [BASIC FEATURES] stored procedures in Postgresql ? - Mailing list pgsql-general

From Doug McNaught
Subject Re: [BASIC FEATURES] stored procedures in Postgresql ?
Date
Msg-id m3snaob4jl.fsf@belphigor.mcnaught.org
Whole thread Raw
In response to [BASIC FEATURES] stored procedures in Postgresql ?  ("Jérôme Courat" <jerome.courat@gecko.fr.eu.org>)
Responses Re: Using Cursor in PostgreSQL 7.2
List pgsql-general
"Jérôme Courat" <jerome.courat@gecko.fr.eu.org> writes:

> Hello,
>
> We have to evaluate the possibility to integrate an open source RDBMS in our
> software developments.
> I checked some stuff on Postgres, but I now have to find out whether
> Postgres integrates Stored Procedures as a feature.

Depends on your definition of "stored procedure".  Postgres allows
user-written functions, stored in the database, and callable from
queries.  What these functions can't currenty do is return result
sets, which is what a lot of people mean by "stored procedure".

However, it's my understanding that in 7.2 (which is currently in
beta) functions can return open cursors, which gives you a lot of the
same functionality as returning result sets.

Also, functions can be written in several languages, including Perl,
Python, and Tcl as well as straight C and PGSQL (which is similar to
Oracle's PL/SQL).

> Can anyone tell me if it does ? In that case, my company would use this
> rdbms for several future products.

I hope my response has been helpful.

-Doug
--
Let us cross over the river, and rest under the shade of the trees.
   --T. J. Jackson, 1863

pgsql-general by date:

Previous
From: "Gregory Wood"
Date:
Subject: Re: update returns 1, but no changes have been made
Next
From: Doug McNaught
Date:
Subject: Re: When do I Vacuum ?