Received: from brasileiro.net (slxwy.dorms.usu.edu [129.123.236.160]) by postgresql.org (8.11.3/8.11.4) with ESMTP id g09G16B17875 for ; Wed, 9 Jan 2002 11:01:06 -0500 (EST) (envelope-from roberto@brasileiro.net) Received: from roberto by brasileiro.net with local (Exim 3.33 #1 (Debian)) id 16OLDO-0005JM-00; Wed, 09 Jan 2002 09:04:34 -0700 Date: Wed, 9 Jan 2002 09:04:33 -0700 From: Roberto Mello To: Unnikrishnan Menon Cc: pgsql-sql@postgresql.org Subject: Re: Porting Oracle Packages Message-ID: <20020109160433.GA20109@cc.usu.edu> References: <005601c197fc$6cee16a0$e90aa8c0@UNNIKRISHNAN> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <005601c197fc$6cee16a0$e90aa8c0@UNNIKRISHNAN> User-Agent: Mutt/1.3.25i X-Archive-Number: 200201/66 X-Sequence-Number: 6156 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...