Stored procedures vs Functions - Mailing list pgsql-general

From SHELTON,MICHAEL (Non-HP-Boise,ex1)
Subject Stored procedures vs Functions
Date
Msg-id FB60DFB2C0E24449AC0C21F743B935410150F87A@xboi02.boi.hp.com
Whole thread Raw
Responses Re: Stored procedures vs Functions
List 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 by date:

Previous
From: Nevermind
Date:
Subject: Re: Database tuning
Next
From: Jeff Davis
Date:
Subject: Re: Stored procedures vs Functions