use of Function - Mailing list pgsql-general

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