Re: [GENERAL] Stored Procedures

Поиск
Список
Период
Сортировка
От Gene Sokolov
Тема Re: [GENERAL] Stored Procedures
Дата
Msg-id 0c3b01bf27a3$c86073a0$0d8cdac3@aktrad.ru
обсуждение исходный текст
Ответ на Stored Procedures  (Jeff MacDonald <jeff@hub.org>)
Список 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 по дате отправления:

Предыдущее
От: "Moray McConnachie"
Дата:
Сообщение: Re: [GENERAL] Stored Procedures
Следующее
От: "Ross J. Reedstrom"
Дата:
Сообщение: Re: [GENERAL] indexed regex select optimisation missing?