Oracle to Postgres

Started by Prachi Jainabout 23 years ago1 messagesgeneral
Jump to latest
#1Prachi Jain
prachijain3@rediffmail.com

Hello All,

I am trying to migrate from Oracle to Postgres. I have a query in
Oracle which has clauses like STARTS WITH and CONNECT BY. For
ex::

SELECT field1, field2, field3 FROM table1
START WITH table1.some1||table1.some2 IN
(
SELECT ...FROM ....WHERE ...
)
CONNECT BY PRIOR ... AND PRIOR ....
...
...

How can i implement the same functionality in Postgres???

Please guide.
thanks and regards