Convert Oracle outer join query to PostgreSql

hergele

Hello all.. I am trying to convert an application which is working on Oracle to postgreSql..
I've seen a query in code something like this...

Expand|Select|Wrap|Line Numbers

 select  *

from    table1 a1 , table1 a2, table2 a3,        

where   a1.childid = a2.parentid(+)

and     a2.childtype (+)= 'Something'

and     a2.parenttype (+)= 'Something'

and     a2.childid = a3.id (+)

It's been used oracle iso99 style (+) outer join as you see..

But..I've searched google, other forums.. But i can't convert this query to postgreSql..(my mind is stopped)
Postgre wants me to use LEFT JOIN RIGHT JOIN, and wants me to use this after the FROM word..
So.. I am confused. Have you got any idea for this query?

Thanks in advance..

r035198x

Try

Expand|Select|Wrap|Line Numbers

 select  *

 from table1 a2  

      left join table1 a1 on (a1.childid = a2.parentid)

       right join table2 a3 on (a2.childid = a3.id) 

       where ( a2.childtype = 'Something' or a2.childtype is null)

       and ( a2.parenttype = 'Something' or a2.parenttype is null)

Convert Oracle outer join query to PostgreSql

re: Convert Oracle outer join query to PostgreSql

Similar PostgreSQL Database bytes

/bytes/development

/bytes/it

/bytes/about