Hello everyone, I'm using postgresql form an year and I have some difficult to write a function to make an report. I'm running PostgreSQL 7.5.3 on i686-pc-linux-gnu (Mandriva 10.1). My table structure is: Tabela " public.matricula" Column | Type | Modifiers
I need to have an output like: ref_pessoa | ref_disciplina1 | ref_disciplina2 | ... | ref_disciplina n 1 | nota_final1 | nota_final2 | ... | nota_final n
How can I make this ? I know that I need to declare an variable an than make an for - loop, but I don't know how. Where can I get some examples for this? Thanks.
-- __________________________ Alguns caminham pelo arco, eu caminho pela reta.
Alexandre Gonçalves Jacarandá Assessor de Tecnologia de Informação Tel.: 0 ** 21 8131-2313