Oracle to Postgres 
Author Message
 Oracle to Postgres

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

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

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate

message can get through to the mailing list cleanly

Sun, 03 Jul 2005 20:36:09 GMT
 [ 1 post ] 

 Relevant Pages 

1. How to SQL with Oracle and Postgres easily

2. [Fwd: FW: Oracle to Postgres data migration -- Please

3. Problems in porting from Oracle to Postgres

4. transfer data from oracle to postgres

5. converting Oracle to postgres

6. [Fwd: FW: Oracle to Postgres data migration -- Please advice.]

7. MySQL vs. Postgres - congratulations to the postgres team

8. concurrent postgres in NUMA cluster postgres - design OK ?

9. enable pl/pgsql in postgres from postgres-server-7.0.3-2 RPM

10. A way to link oracle DB to postgres DB for data transfer

11. Migration from Postgres to Oracle under solaris

12. DBPowerSuite for Postgres, MySQL, Sybase and Oracle

Powered by phpBB® Forum Software