From: rute solipa <rutes@eselx.ipl.pt>
To: pgsql-sql@postgresql.org
Subject: HELP
Date: Wed, 16 Apr 2003 11:28:29 +0100
Message-ID: <5.0.2.1.0.20030416112346.00a48080@mail.eselx.ipl.pt> (raw)
hi everyone, i realy need help.
does any one nows how to alter this oracle 9i query to postgresql.
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 tb_mensagens_monitores where tb_mensagens_monitores.id_resposta is null)
mensagens, (select id_resposta, count(id_mensagem) respondidas
from tb_mensagens_monitores group by id_resposta) respostas
where mensagens.id_mensagem = respostas.id_resposta(+)
and i <= 30 order by ds_date desc
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
In-Reply-To: <5.0.2.1.0.20030416112346.00a48080@mail.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