[postgis-users] Returning multiple fields froma plpgsql function

[Paragon Corporation]

Steve,

We wrote up on how to use OUT and INOUT parameters.  Hopefully this will be
of use to some thinking about it.  We also discovered it is supported in 8.1
so more downward compatible than we thought.

http://www.postgresonline.com/journal/index.php?/archives/129-Use-of-OUT-and
-INOUT-Parameters.html


Leo 

-----Original Message-----
From: postgis-users-bounces at postgis.refractions.net
[mailto:postgis-users-bounces at postgis.refractions.net] On Behalf Of Mark
Cave-Ayland
Sent: Thursday, July 30, 2009 12:12 PM
To: PostGIS Users Discussion
Subject: Re: [postgis-users] Returning multiple fields froma plpgsql
function

Stephen Woodbridge wrote:

> Leo and David,
> 
> Thanks! Both of these ideas are really cool. I have not seen either of 
> them in use before. I just recently made the jump from 8.1 to 8.3 and 
> have not had time to check out all of the new features. I have got to 
> make more time to read up on this stuff.
> 
> It sounds like the (my_function(x,y)).* will likely be more backwards 
> compatible, but I like the OUT params as being a cleaner 
> implementation and it is a pain to have to create and manage the types 
> if you have a lot of functions like this, especially when you want to 
> redefine the type, you have to drop cascade the type and then reload 
> everything that referenced it.
> 
> Many thanks guys,
>   -Steve

+1 for the use of OUT params. I used these on my last development
project, and the ability to call stored procedures without managing extra
types was a real plus.


HTH,

Mark.

-- 
Mark Cave-Ayland - Senior Technical Architect
PostgreSQL - PostGIS
Sirius Corporation plc - control through freedom
http://www.siriusit.co.uk
t: +44 870 608 0063
_______________________________________________
postgis-users mailing list
postgis-users at postgis.refractions.net
http://postgis.refractions.net/mailman/listinfo/postgis-users