[postgis-users] Returning multiple fields from a plpgsql function

[Mark Cave-Ayland]

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