Re: Retrieve the column values of a record without knowing the names

Wow, I don't know if I exposed the problem in the right way, but I'm not
achieving the solution with information_schema... Let me show the function:

CREATE OR REPLACE FUNCTION fc_teste_tce2(codigo_aluno integer) RETURNS character varying AS
$BODY$ 
DECLARE reg record; reg2 record; msg character varying; i integer;
BEGIN msg := ''; i := 0; for reg in SELECT * FROM estagio.vw_aluno_tce where aluno::integer =
codigo_aluno loop   for reg2 in select column_name    from information_schema.columns     where table_catalog = 'seduc'
and          table_schema = 'estagio' and           table_name = 'vw_aluno_tce' loop         if reg.reg2.column_name =
''then --> how can I do this to check
 
if there's no value for the field?           i := 1;         end if; end loop;           end loop; if (i = 1) then
return'Problems...'; else   return 'ok'; end if;
 
END;  
$BODY$ LANGUAGE plpgsql VOLATILE COST 100;


Thanks a lot!
-- 
View this message in context:
http://postgresql.1045698.n5.nabble.com/Retrieve-the-column-values-of-a-record-without-knowing-the-names-tp3387932p3390966.html
Sent from the PostgreSQL - sql mailing list archive at Nabble.com.