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

Re: returning multiple result sets from a stored procedure

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: Darren Duncan <darren(at)darrenduncan(dot)net>
Cc: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: returning multiple result sets from a stored procedure
Date: 2010-09-10 04:47:27
Message-ID: 1284094047.31815.0.camel@vanquo.pezone.net (view raw or flat)
Thread:
Lists: pgsql-hackers
On tor, 2010-09-09 at 13:08 -0700, Darren Duncan wrote:
> Since Pg's FUNCTION already seems to take on both roles, so
> overloading the meaning of the FUNCTION keyword, like what a C
> function or a Perl sub does, where returning VOID means procedure,
> then what is being added by a distinct PROCEDURE?

I'd just like to have the CALL statement, because

CALL do_something();

looks better than

SELECT do_something();

Small details ...


In response to

Responses

pgsql-hackers by date

Next:From: Peter EisentrautDate: 2010-09-10 04:49:16
Subject: Re: returning multiple result sets from a stored procedure
Previous:From: Tom LaneDate: 2010-09-10 03:43:49
Subject: Re: git: uh-oh

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