Re: Function and RowType

Working with 7.4.3

CREATE TABLE a_preuba (
  codigo       varchar(2)           not null,
  descripcion  varchar(250)         not null,
  valor        integer,
  hora         date
);

Function that constructs and returns rowtype:
CREATE OR REPLACE FUNCTION retornar_record(VARCHAR)
RETURNS  a_prueba  AS '
DECLARE
    retorno  a_prueba%rowtype;
    sbestacodi alias for $1;
BEGIN
     SELECT INTO retorno * FROM a_prueba where codigo
= sbestacodi ;
    RETURN retorno;
END;
' LANGUAGE plpgsql;

Function that receives rowtype and writes its content
:
CREATE OR REPLACE FUNCTION probar_record(a_prueba)
RETURNS  varchar AS '
DECLARE
    registro ALIAS FOR $1;
BEGIN
  RAISE NOTICE  '' Código : % Descripción : % Valor  :
 % '',
                 registro.codigo,registro.descripcion,
                 registro.valor;
  RETURN registro.descripcion;
END;
' LANGUAGE plpgsql;


Use of the functions :
1. CREATE OR REPLACE FUNCTION probar()
2.  RETURNS text AS'
3. DECLARE
4.     reg   a_prueba%ROWTYPE;
5. BEGIN
      --To initialize a ROWTYPE
6.    SELECT * INTO reg  FROM retornar_record(''06'');
7.    reg.codigo := ''99'';

        -- It works within a consultation
8.       PERFORM  probar_record(t.*)
                 from a_prueba  t
                  where codigo = ''06'';

       -- It works with a function that returns
rowtype
       --Directly
9.     PERFORM
probar_record(retornar_record(''01''));

       --IT DOES NOT WORK
10.    PERFORM   probar_record(reg);

11.   RETURN NULL;
12. END;
13. ' LANGUAGE plpgsql;

If you observe in line 6 and 7 I initialize rowtype
and I modify it but in 10, line treatment to pass it
to the function and says to me that reg is not a
column;  The calls in line 8 and 9 funciónan, i find
in some forums and probe but I have not been able to
find nothing for line 10, because I need to modify
rowtype before passing it.  Some idea?

_________________________________________________________
Do You Yahoo!?
Información de Estados Unidos y América Latina, en Yahoo! Noticias.
Visítanos en http://noticias.espanol.yahoo.com