X-Original-To: pgsql-sql@postgresql.org Received: from spampd.localdomain (postgresql.org [64.49.215.8]) by postgresql.org (Postfix) with ESMTP id E1FC4475EDF for ; Mon, 28 Apr 2003 11:52:50 -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 D61A3475B47 for ; Mon, 28 Apr 2003 11:52:48 -0400 (EDT) Received: (qmail 13013 invoked by uid 508); 28 Apr 2003 16:52:53 +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.070763 secs); 28 Apr 2003 15:52:53 -0000 X-IPLNet-RcptTo: pgsql-sql@postgresql.org Received: from matrix.eselx.ipl.pt (193.137.237.148) by 0 with SMTP; 28 Apr 2003 16:52:52 +0100 Received: from [172.21.3.60] (helo=eselx.ipl.pt) by matrix.eselx.ipl.pt with esmtp (Exim 3.35 #1 (Debian)) id 19AAvc-0001NI-00 for ; Mon, 28 Apr 2003 16:52:28 +0100 Message-ID: <3EAD4E78.80204@eselx.ipl.pt> Date: Mon, 28 Apr 2003 16:53:28 +0100 From: rute solipa 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" Subject: help query Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Spam-Status: No, hits=-12.5 required=5.0 tests=BAYES_01,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/419 X-Sequence-Number: 13120 hi everyone, i've got this oracle query, and i need it to put it to work in potgresql platform, i think the right outer join it will do just fine, but i don't now where to put , can anyone help me: select id_mensagem, ds_description, e_mail, to_char(date,'DD/MM/YY - HH24:MI') as Date, assunto, respondidas, mensagem, mensagens.id_resposta from (select id_mensagem, ds_description, e_mail, date, assunto, mensagem, id_resposta from tb_mensagens_monitores where tb_mensagens_monitores.id_resposta is null) mensagens, (select id_resposta, count(id_mensagem) as respondidas from tb_mensagens_monitores group by id_resposta) as respostas where mensagens.id_mensagem = respostas.id_resposta(+) order by date kind regards, rute