Re: Possible move away from PG

On Thu, 30 Jun 2005, Jason Tesser wrote:

> 1. Our dev plan involves alot of stored procedures to be used and we
> have found the way this is done in PG to be painful. (ie.  To return
> multiple record from different tables you have to define a type.  This
> is a pain to maintain because if you ever have to change what it returns
> it cannot be dropped because of dependencies etc.. In some other
> databases you can simpley write a stored proc to return whatever the
> query inside returns and this is handled dynamically)

Have you considered returing refcursors instead of setof some type.

Kris Jurka