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

returning multiple result sets from a stored procedure

From: John Adams <john_adams_mail(at)yahoo(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: returning multiple result sets from a stored procedure
Date: 2010-09-02 22:25:45
Message-ID: 867486.80027.qm@web114314.mail.gq1.yahoo.com (view raw or flat)
Thread:
Lists: pgsql-hackers
I noticed in postgres you cannot return multiple result sets from a stored 
procedure (surprisingly as it looks like a very good dbms). 

I would like to suggest adding this feature. 
- It is very usefull
- It is supported by all other dbmss I have worked with.
- makes porting applications to postgres very difficult (we have used this 
feature in our stored procedures and now there is no easy way of porting to 
postgres)
Thanks and we are waiting


      

Responses

pgsql-hackers by date

Next:From: Alvaro HerreraDate: 2010-09-02 23:17:00
Subject: Re: returning multiple result sets from a stored procedure
Previous:From: Tom LaneDate: 2010-09-02 22:21:09
Subject: Re: Replacing the pg_get_expr security hack with a datatype solution

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