pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedhelp query
4+ messages / 3 participants
[nested] [flat]
* help query
@ 2003-04-28 15:53 rute solipa <rutes@eselx.ipl.pt>
2003-04-28 15:56 ` Re: help query Rajesh Kumar Mallah <rmallah@trade-india.com>
2003-04-29 09:48 ` Re: help query rute solipa <rutes@eselx.ipl.pt>
0 siblings, 2 replies; 4+ messages in thread
From: rute solipa @ 2003-04-28 15:53 UTC (permalink / raw)
To: pgsql-sql
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: help query
2003-04-28 15:53 help query rute solipa <rutes@eselx.ipl.pt>
@ 2003-04-28 15:56 ` Rajesh Kumar Mallah <rmallah@trade-india.com>
1 sibling, 0 replies; 4+ messages in thread
From: Rajesh Kumar Mallah @ 2003-04-28 15:56 UTC (permalink / raw)
To: rute solipa <rutes@eselx.ipl.pt>; +Cc: pgsql-sql
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
>
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: help query
2003-04-28 15:53 help query rute solipa <rutes@eselx.ipl.pt>
@ 2003-04-29 09:48 ` rute solipa <rutes@eselx.ipl.pt>
2003-04-29 10:44 ` Re: help query Victor Yegorov <viy@nordlb.lv>
1 sibling, 1 reply; 4+ messages in thread
From: rute solipa @ 2003-04-29 09:48 UTC (permalink / raw)
To: Rajesh Kumar Mallah <rmallah@trade-india.com>; +Cc: pgsql-sql
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
> >
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: help query
2003-04-28 15:53 help query rute solipa <rutes@eselx.ipl.pt>
2003-04-29 09:48 ` Re: help query rute solipa <rutes@eselx.ipl.pt>
@ 2003-04-29 10:44 ` Victor Yegorov <viy@nordlb.lv>
0 siblings, 0 replies; 4+ messages in thread
From: Victor Yegorov @ 2003-04-29 10:44 UTC (permalink / raw)
To: rute solipa <rutes@eselx.ipl.pt>; +Cc: Rajesh Kumar Mallah <rmallah@trade-india.com>; pgsql-sql
* rute solipa <rutes@eselx.ipl.pt> [29.04.2003 13:36]:
> 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,
Go here:
http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=queries-table-expressions.ht...
and read all about joins.
--
Victor Yegorov
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2003-04-29 10:44 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-04-28 15:53 help query rute solipa <rutes@eselx.ipl.pt>
2003-04-28 15:56 ` Rajesh Kumar Mallah <rmallah@trade-india.com>
2003-04-29 09:48 ` rute solipa <rutes@eselx.ipl.pt>
2003-04-29 10:44 ` Victor Yegorov <viy@nordlb.lv>
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