Oracle to Postgres

From: "Prachi Jain" <prachijain3(at)rediffmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Oracle to Postgres
Date: 2003-01-15 12:31:42
Message-ID: 20030115123142.30549.qmail@webmail27.rediffmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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

Browse pgsql-general by date

  From Date Subject
Next Message Dave Cramer 2003-01-15 12:55:54 Re: [JDBC] JDBC
Previous Message Scott Taylor 2003-01-15 12:01:33 JDBC to PostgreSQL on Cygwin