From: rute solipa <rutes@eselx.ipl.pt>
To: pgsql-sql@postgresql.org <pgsql-sql@postgresql.org>
Subject: help query
Date: Mon, 28 Apr 2003 16:53:28 +0100
Message-ID: <3EAD4E78.80204@eselx.ipl.pt> (raw)
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
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 query
In-Reply-To: <3EAD4E78.80204@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