Re: [GENERAL] Stored Procedures

From: "Gene Sokolov" <hook(at)aktrad(dot)ru>
To: <pgsql-general(at)postgreSQL(dot)org>
Subject: Re: [GENERAL] Stored Procedures
Date: 1999-11-05 15:38:18
Message-ID: 0c3b01bf27a3$c86073a0$0d8cdac3@aktrad.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Brett W. McCoy 1999-11-05 15:52:24 Re: [GENERAL] Stored Procedures
Previous Message Ross J. Reedstrom 1999-11-05 15:36:55 Re: [GENERAL] indexed regex select optimisation missing?