Skip site navigation (1) Skip section navigation (2)

Stored procedures vs Functions

From: "SHELTON,MICHAEL (Non-HP-Boise,ex1)" <michael_shelton(at)non(dot)hp(dot)com>
To: "'Tom Lane'" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Stored procedures vs Functions
Date: 2001-12-21 20:27:30
Message-ID: FB60DFB2C0E24449AC0C21F743B935410150F87A@xboi02.boi.hp.com (view raw or flat)
Thread:
Lists: 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

Responses

pgsql-general by date

Next:From: Jeff DavisDate: 2001-12-21 21:20:45
Subject: Re: Stored procedures vs Functions
Previous:From: NevermindDate: 2001-12-21 20:17:47
Subject: Re: Database tuning

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group