Re: [GENERAL] Stored Procedures

On Fri, 5 Nov 1999, Jeff MacDonald wrote:

> 	1: does postgres support stored procedures

Yes, quite extensively, and far beyond what SQL 7 offers.  You may want 
to take a look at the programmer's manual for the documentation.

> 	2: say a user has a microsoft sql server 7 database
> 	with ~120 stored procedures, and alot of data, is their
> 	a script or tool to convert that to a postgres database
> 	or does it have to be done by hand.
> 

You can convert the data over with ODBC, but not the stored procedures. 
Under SQL 7, stored procedures are essentially SQL batch files and cannot
be used as a term in an expression, whereas under PostgreSQL, you can
create true functions in PL/PgSQL (a procedural language akin to
Oracle's), or as loadable executable modules written in C, C++, Tcl, etc.,
that returns values and objects, and can be used in an expression. 

I was shocked recently when we put in SQL 7 in our office (we've been 
using PostgreSQL for a while now, but we needed SQL 7 to use with a 
commercial retrieval system) and needed to start writing functions as I 
was used to under PostgreSQL, and couldn't.  A big win for PostgreSQL!

Brett W. McCoy           
                                         http://www.lan2wan.com/~bmccoy
-----------------------------------------------------------------------
There are people so addicted to exaggeration that they can't tell the
truth without lying.