From: rute solipa <rutes@eselx.ipl.pt>
To: Rajesh Kumar Mallah <rmallah@trade-india.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: help query
Date: Tue, 29 Apr 2003 10:48:41 +0100
Message-ID: <5.0.2.1.0.20030429101227.00a4d490@mail.eselx.ipl.pt> (raw)
In-Reply-To: <Pine.LNX.4.33.0304282125210.868-100000@localhost.localdoma in>
References: <3EAD4E78.80204@eselx.ipl.pt>
hi everyone,
does anyone can help me with this query, i need to now if it's a possible
query and where do i put the join clause.
kind regards,
rute
At 21:26 28-04-2003 +0530, you wrote:
>Hmm as far i remember its the thrid of its kind
>in past one month :)
>
>dealing with oracle (+) join syntax :(
>
>On Mon, 28 Apr 2003, rute solipa wrote:
>
> > 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
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 6: Have you searched our list archives?
> >
> > http://archives.postgresql.org
> >
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, rmallah@trade-india.com
Subject: Re: help query
In-Reply-To: <5.0.2.1.0.20030429101227.00a4d490@mail.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