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