On Fri, Dec 16, 2005 at 14:03:14 -0200,
Alexandre Gonçalves Jacarandá <[EMAIL PROTECTED]> wrote:
> Guys, I can do what I need but I have other problem: How can I named
> columns with another data ? For example:
You might be better off doing this in your application rather than entirely
with sql.
Guys, I can do what I need but I have other problem: How can I named
columns with another data ? For example:
select * from crosstab('select pessoa_nome(ref_pessoa), ref_disciplina,
nota_final from matricula where ref_periodo = ''25CASI'' order by 1,2',
'select ref_disciplina from disciplinas_ofer
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
Have you considered using a view to create the report?
AaronOn 12/7/05, Alexandre Gonçalves Jacarandá <[EMAIL PROTECTED]> wrote:
Hello everyone, I'm using postgresql form an year and I have somedifficult to write a function to make an report. I'm running PostgreSQL7.5.3 on i686-pc-linux-gnu (Mandr
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
