Re: [GENERAL] Newbie: help with FUNCTION

2005-02-25 Thread Rick Apichairuk
> > On Thu, Feb 24, 2005 at 09:00:46PM +, Charl Gerber wrote: > > I'm trying to create a function that takes 1 > > paramater (eg an integer) as input, then does 5 > > database updates or deletes in 5 different SQL > > statements and returns 5 integers (in one resultset) > > indicating how many

Re: [GENERAL] Newbie: help with FUNCTION

2005-02-25 Thread elein
Alternatives to returning a set of rows is to return a set of integers, one per row selected. Same example as Huxton's without the row type. Also you could return an array of integers. --elein On Thu, Feb 24, 2005 at 09:00:46PM +, Charl Gerber wrote: > I'm trying to create a function that

Re: [GENERAL] Newbie: help with FUNCTION

2005-02-25 Thread Richard Huxton
Charl Gerber wrote: I'm trying to create a function that takes 1 paramater (eg an integer) as input, then does 5 database updates or deletes in 5 different SQL statements and returns 5 integers (in one resultset) indicating how many rows were affected by the various updates/deletes. How do I do th