Stored procedures vs Functions

Поиск
Список
Период
Сортировка
От SHELTON,MICHAEL (Non-HP-Boise,ex1)
Тема Stored procedures vs Functions
Дата
Msg-id FB60DFB2C0E24449AC0C21F743B935410150F87A@xboi02.boi.hp.com
обсуждение исходный текст
Ответы Re: Stored procedures vs Functions  (Jeff Davis <list-pgsql-general@dynworks.com>)
Список pgsql-general
Tom,

I've switched topics so I started a new thread, but your last comment about
7.2 made me think of a lingering question I've had.  I've seen posts about
stored procedures and functions not being able to return result sets, etc.

In my last job I did e-commerce on a win2k platform with SQL 7.0.  We used
stored procedures extensively and found them to be very advantageous
(especially on the occasions we need to return 2 different result sets from
2 different queries within the stored proc).  My question then:  are there
stored procedures that execute like SQL 7.0 stored procs and if so are they
functions and if so do I need to use a specific language or syntax?

Thanks,

Mike Shelton

В списке pgsql-general по дате отправления:

Предыдущее
От: Nevermind
Дата:
Сообщение: Re: Database tuning
Следующее
От: Jeff Davis
Дата:
Сообщение: Re: Stored procedures vs Functions