From: | rute solipa <rutes(at)eselx(dot)ipl(dot)pt> |
---|---|
To: | "pgsql-sql(at)postgresql(dot)org" <pgsql-sql(at)postgresql(dot)org> |
Subject: | help need it |
Date: | 2003-04-15 15:52:07 |
Message-ID: | 3E9C2AA7.8040305@eselx.ipl.pt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-sql |
hi everyone,
i've got an oracle query that is something like this:
select id_mensagem, ds_description, e_mail, to_char(ds_date,'DD/MM/YY -
HH24:MI'), assunto,
respondidas, mensagem, mensagens.id_resposta
from
(select id_mensagem, ds_description, e_mail, ds_date, assunto,
mensagem, id_resposta,
RANK() OVER ( ORDER BY id_mensagem desc )as i
from varForum
where varForum.id_resposta varIdComparator) mensagens,
(select id_resposta, count(id_mensagem) respondidas
from varForum
group by id_resposta) respostas
where mensagens.id_mensagem = respostas.id_resposta(+)
varRange
order by ds_date desc
now i need to pass the query to postgresql, does any one can help me.
best regards,
etur
From | Date | Subject | |
---|---|---|---|
Next Message | Richard Huxton | 2003-04-15 16:29:45 | Re: [PERFORM] Yet Another (Simple) Case of Index not used |
Previous Message | Adam Sherman | 2003-04-15 14:53:52 | Percentage of Total Occurances |