Output function - Mailing list pgsql-general

From Uro Gruber
Subject Output function
Date
Msg-id 4517402813.20001228172149@sir-mag.com
Whole thread Raw
List pgsql-general
Hi!

This is some function.

CREATE FUNCTION my_func(text) RETURNS text AS '
   DECLARE
     name TEXT;
     lastname TEXT;
   BEGIN
     name := ''Uros'';
     lastname := ''Gruber'';
     RETURN ime;
   END;
' LANGUAGE 'plpgsql';

Output is like this

 my_func
--------
 Uros
(1 row)

What i want to do is output like this


   name     |        lastname
------------+------------------
   uros     |         gruber
(1 row)

How can i write this function to return both values?


--
Thanks, Uros



pgsql-general by date:

Previous
From: Adam Rossi
Date:
Subject: Re: How I can join between the other database's tables?
Next
From: Adam Haberlach
Date:
Subject: void UPDATE function?