pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPorting Oracle Packages
3+ messages / 3 participants
[nested] [flat]
* Porting Oracle Packages
@ 2002-01-08 04:24 Unnikrishnan Menon <unnikrishnan.menon@chennai.transys.net>
0 siblings, 2 replies; 3+ messages in thread
From: Unnikrishnan Menon @ 2002-01-08 04:24 UTC (permalink / raw)
To: 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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Porting Oracle Packages
@ 2002-01-08 20:29 Josh Berkus <josh@agliodbs.com>
parent: Unnikrishnan Menon <unnikrishnan.menon@chennai.transys.net>
1 sibling, 0 replies; 3+ messages in thread
From: Josh Berkus @ 2002-01-08 20:29 UTC (permalink / raw)
To: Unnikrishnan Menon <unnikrishnan.menon@chennai.transys.net>; 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@agliodbs.com
and data management solutions (415) 565-7293
for law firms, small businesses fax 621-2533
and non-profit organizations. San Francisco
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Porting Oracle Packages
@ 2002-01-09 16:04 Roberto Mello <rmello@cc.usu.edu>
parent: Unnikrishnan Menon <unnikrishnan.menon@chennai.transys.net>
1 sibling, 0 replies; 3+ messages in thread
From: Roberto Mello @ 2002-01-09 16:04 UTC (permalink / raw)
To: Unnikrishnan Menon <unnikrishnan.menon@chennai.transys.net>; +Cc: 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...
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2002-01-09 16:04 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2002-01-08 04:24 Porting Oracle Packages Unnikrishnan Menon <unnikrishnan.menon@chennai.transys.net>
2002-01-08 20:29 ` Josh Berkus <josh@agliodbs.com>
2002-01-09 16:04 ` Roberto Mello <rmello@cc.usu.edu>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox