Re: Help on function creating - Mailing list pgsql-sql
From | Alexandre Gonçalves Jacarandá |
---|---|
Subject | Re: Help on function creating |
Date | |
Msg-id | 439817E1.2070708@yahoo.com.br Whole thread Raw |
In response to | Help on function creating (Alexandre Gonçalves Jacarandá<clark_vr@yahoo.com.br>) |
List | pgsql-sql |
Thanks Andrew, Osvaldo ( Obrigado) and Aaron !! Sory Andrew the right version number is 7.4.3 and I'll study the crosstab because it's seems to fit for sutuation. See you... Andrew Sullivan escreveu: > I think you can do this with the contrib/crosstab stuff. But AFAIK, > there's no such thing as Pg 7.5.3. > > A > > On Wed, Dec 07, 2005 at 10:26:53AM -0200, Alexandre Gonçalves Jacarandá wrote: > >>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 0 >> nota_exame | double precision | default 0 >> nota_final | double precision | default 0 >> conceito | character varying(5) | default >>''::character varying >> conceito_exame | character varying(5) | default >>''::character varying >> conceito_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 >> >> >>---------------------------(end of broadcast)--------------------------- >>TIP 3: Have you checked our extensive FAQ? >> >> http://www.postgresql.org/docs/faq > > -- __________________________ 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