Re: [GENERAL] Stored Procedures - Mailing list pgsql-general

From Gene Sokolov
Subject Re: [GENERAL] Stored Procedures
Date
Msg-id 0c3b01bf27a3$c86073a0$0d8cdac3@aktrad.ru
Whole thread Raw
In response to Stored Procedures  (Jeff MacDonald <jeff@hub.org>)
List pgsql-general
> 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.




pgsql-general by date:

Previous
From: "Moray McConnachie"
Date:
Subject: Re: [GENERAL] Stored Procedures
Next
From: "Ross J. Reedstrom"
Date:
Subject: Re: [GENERAL] indexed regex select optimisation missing?