Hi!
Here is my problem.
I have one table with some data and i want to make some
function.
This function must do some data reordering and delete
something and then return some data.
I make almost everything exept returning data. I want return
five filelds of row and not just text.
I call this function like
SELECT myfunction(argument)
and when i call this it delete some data, then i calculate
some values and update it. And then i want outpu to
something like this.
Id | date | name | status
00304 | 24.06.01 | mike | new
CREATE function myfunction(string) RETURNS text
^^^^
how can i tell
here to return like int,datetime,varchar,varchar. Is it
possible to use return SET or something.
Now i have solution like function return me id and then i
use normal select to get this data. But i would like to have
only one function to do this.
Any sugestions.
thanks, Uros