Re: [GENERAL] Stored Procedures

> 1: does postgres support stored procedures

Yes, but they can't return datasets in any meaningfull way. They can return
single values only.

> 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 have to rewrite your procedures if they return rows. IMO, this is the
major deficiency of Postgers.

Gene Sokolov.