Lists: | pgsql-sql |
---|
From: | "Unnikrishnan Menon" <unnikrishnan(dot)menon(at)chennai(dot)transys(dot)net> |
---|---|
To: | <pgsql-sql(at)postgresql(dot)org> |
Subject: | Porting Oracle Packages |
Date: | 2002-01-08 04:24:49 |
Message-ID: | 005601c197fc$6cee16a0$e90aa8c0@UNNIKRISHNAN |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-sql |
Hi,
1.I have a package in Oracle to be ported to PostgreSQL.
The package consists of three procedures.
Anybody could give any suggestion on the porting methodology.
2. Any idea as to what is the equivalent of the following Oracle code in Postgresql:
Type xyz is Table of userid.user_account%type index by binary_integer;
prev_id xyz;
dummy xyz;
Thanx in advance,
Unnikrishnan
From: | "Josh Berkus" <josh(at)agliodbs(dot)com> |
---|---|
To: | "Unnikrishnan Menon" <unnikrishnan(dot)menon(at)chennai(dot)transys(dot)net>, <pgsql-sql(at)postgresql(dot)org> |
Subject: | Re: Porting Oracle Packages |
Date: | 2002-01-08 20:29:33 |
Message-ID: | web-550114@davinci.ethosmedia.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-sql |
Unnikrishnan,
(wow! Don't you have a nickname?)
> 1.I have a package in Oracle to be ported to PostgreSQL.
> The package consists of three procedures.
> Anybody could give any suggestion on the porting methodology.
See: http://techdocs.postgresql.org/
there are considerable resources for Oracle --> postgres porting there.
-Josh
______AGLIO DATABASE SOLUTIONS___________________________
Josh Berkus
Complete information technology josh(at)agliodbs(dot)com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
From: | Roberto Mello <rmello(at)cc(dot)usu(dot)edu> |
---|---|
To: | Unnikrishnan Menon <unnikrishnan(dot)menon(at)chennai(dot)transys(dot)net> |
Cc: | pgsql-sql(at)postgresql(dot)org |
Subject: | Re: Porting Oracle Packages |
Date: | 2002-01-09 16:04:33 |
Message-ID: | 20020109160433.GA20109@cc.usu.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Lists: | pgsql-sql |
On Tue, Jan 08, 2002 at 09:54:49AM +0530, Unnikrishnan Menon wrote:
>
> 1.I have a package in Oracle to be ported to PostgreSQL.
> The package consists of three procedures.
> Anybody could give any suggestion on the porting methodology.
Josh already pointed you to the docs, so I won't do it again :)
> 2. Any idea as to what is the equivalent of the following Oracle code in Postgresql:
>
> Type xyz is Table of userid.user_account%type index by binary_integer;
> prev_id xyz;
> dummy xyz;
There's no structure in PL/pgSQL or any of the PostgreSQL procedural
languages that will map directly to this.
I remember I ported procedures with "type foo is Table of bar..." using
PL/Tcl arrays once, but it wasn't pretty.
Best thing is to think what are you trying to _accomplish_ with the
procedure, and then re-write it as a PL/pgSQL function.
-Roberto
--
+----| http://fslc.usu.edu/ USU Free Software & GNU/Linux Club |------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.net/
http://www.sdl.usu.edu/ - Space Dynamics Lab, Developer
7 Days without pizza makes one weak...