X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id 1DAC6475EFD for ; Wed, 16 Apr 2003 06:39:02 -0400 (EDT) Received: from smtp-out.net.ipl.pt (31.220.137.193.in-addr.arpa [193.137.220.31]) by postgresql.org (Postfix) with ESMTP id 91604475E14 for ; Wed, 16 Apr 2003 06:39:00 -0400 (EDT) Received: (qmail 7061 invoked by uid 508); 16 Apr 2003 11:39:02 +0100 Received: from rutes@eselx.ipl.pt by smtp-int.net.ipl.pt by uid 505 with qmail-scanner (sophie: 2.14/3.68. spamassassin: 2.50. Clear:. Processed in 0.070069 secs); 16 Apr 2003 10:39:02 -0000 X-IPLNet-RcptTo: pgsql-sql@postgresql.org Received: from matrix.eselx.ipl.pt (193.137.237.148) by 0 with SMTP; 16 Apr 2003 11:39:01 +0100 Received: from intranet.eselx.ipl.pt ([193.137.237.149] helo=acad_rute.eselx.ipl.pt) by matrix.eselx.ipl.pt with esmtp (Exim 3.35 #1 (Debian)) id 195kJF-000128-00 for ; Wed, 16 Apr 2003 11:38:33 +0100 Message-Id: <5.0.2.1.0.20030416112346.00a48080@mail.eselx.ipl.pt> X-Sender: rutes@mail.eselx.ipl.pt X-Mailer: QUALCOMM Windows Eudora Version 5.0.2 Date: Wed, 16 Apr 2003 11:28:29 +0100 To: pgsql-sql@postgresql.org From: rute solipa Subject: HELP Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii"; format=flowed X-Spam-Status: No, hits=-3.1 required=5.0 tests=BAYES_20 version=2.50 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp) X-Archive-Number: 200304/252 X-Sequence-Number: 12953 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