| From: | rute solipa <rutes(at)eselx(dot)ipl(dot)pt> |
|---|---|
| To: | pgsql-sql(at)postgresql(dot)org |
| Subject: | HELP |
| Date: | 2003-04-16 10:28:29 |
| Message-ID: | 5.0.2.1.0.20030416112346.00a48080@mail.eselx.ipl.pt |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-sql |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | pginfo | 2003-04-16 12:52:55 | Re: changing column size and type. |
| Previous Message | pginfo | 2003-04-16 09:16:05 | Re: changing column size and type. |