Help on function creating

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

-------------------------+--------------------------+-------------------------------------------------id
     | integer                  | not null default
 
nextval('seq_matricula'::text)ref_contrato            | integer                  |ref_pessoa              | integer
            |ref_campus              | integer                  |ref_curso               | integer
|ref_periodo            | character varying(10)    |ref_disciplina          | integer                  |ref_curso_subst
       | integer                  |ref_disciplina_subst    | integer                  |ref_disciplina_ofer     |
integer                 |nota                    | double precision         | default 0nota_exame              | double
precision        | default 0nota_final              | double precision         | default 0conceito                |
charactervarying(5)     | default
 
''::character varyingconceito_exame          | character varying(5)     | default
''::character varyingconceito_final          | character varying(5)     | default
''::character varying

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



    
_______________________________________________________ 
Yahoo! doce lar. Faça do Yahoo! sua homepage. 
http://br.yahoo.com/homepageset.html