X-Original-To: pgsql-sql@postgresql.org
Received: from spampd.localdomain (postgresql.org [64.49.215.8])
	by postgresql.org (Postfix) with ESMTP id 7F7BD47634D
	for <pgsql-sql@postgresql.org>; Tue, 15 Apr 2003 11:52:03 -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 F3449476349
	for <pgsql-sql@postgresql.org>; Tue, 15 Apr 2003 11:52:01 -0400 (EDT)
Received: (qmail 12456 invoked by uid 508); 15 Apr 2003 16:51:56 +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.067077
	secs); 15 Apr 2003 15:51:56 -0000
X-IPLNet-RcptTo: pgsql-sql@postgresql.org
Received: from matrix.eselx.ipl.pt (193.137.237.148)
	by 0 with SMTP; 15 Apr 2003 16:51:55 +0100
Received: from [172.21.3.60] (helo=eselx.ipl.pt)
	by matrix.eselx.ipl.pt with esmtp (Exim 3.35 #1 (Debian))
	id 195SiU-0006Ww-00
	for <pgsql-sql@postgresql.org>; Tue, 15 Apr 2003 16:51:26 +0100
Message-ID: <3E9C2AA7.8040305@eselx.ipl.pt>
Date: Tue, 15 Apr 2003 16:52:07 +0100
From: rute solipa <rutes@eselx.ipl.pt>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US;
	rv:1.3) Gecko/20030312
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: "pgsql-sql@postgresql.org" <pgsql-sql@postgresql.org>
Subject: help need it
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Spam-Status: No, hits=-11.7 required=5.0
	tests=BAYES_10,TO_ADDRESS_EQ_REAL,USER_AGENT_MOZILLA_UA
	autolearn=ham	version=2.50
X-Spam-Level: 
X-Spam-Checker-Version: SpamAssassin 2.50 (1.173-2003-02-20-exp)
X-Archive-Number: 200304/230
X-Sequence-Number: 12931

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