pg.ddx.io  pgsql-sql@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Porting 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