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
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
