Re: help query

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
>