From: rute solipa <rutes@eselx.ipl.pt>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: help need it
Date: Tue, 15 Apr 2003 16:52:07 +0100
Message-ID: <3E9C2AA7.8040305@eselx.ipl.pt> (raw)
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: rutes@eselx.ipl.pt
Subject: Re: help need it
In-Reply-To: <3E9C2AA7.8040305@eselx.ipl.pt>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox