Received: from fslc.ser.usu.edu (fslc.ser.usu.edu [129.123.28.122]) by postgresql.org (8.11.3/8.11.1) with ESMTP id f4BF6BA16309 for ; Fri, 11 May 2001 11:06:11 -0400 (EDT) (envelope-from rmello@fslc.usu.edu) Received: (from rmello@localhost) by fslc.ser.usu.edu (8.12.0.Beta5/8.12.0.Beta5/Debian 8.12.0-1) id f4BF65U6019325; Fri, 11 May 2001 09:06:05 -0600 Date: Fri, 11 May 2001 09:06:05 -0600 From: Roberto Mello To: Amit Cc: pgsql-sql@postgresql.org Subject: Re: [HACKERS] Problems in porting from Oracle to Postgres Message-ID: <20010511090605.A19164@cc.usu.edu> References: <3AFB8CA1.5B1055B1@rediffmail.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.3.17i In-Reply-To: <3AFB8CA1.5B1055B1@rediffmail.com>; from amitsaxena178@rediffmail.com on Fri, May 11, 2001 at 12:24:25PM +0530 X-Archive-Number: 200105/98 X-Sequence-Number: 2910 This is more appropriate for the pgsql-sql list, so im forwarding it that way. The hackers list is for other purposes. On Fri, May 11, 2001 at 12:24:25PM +0530, Amit wrote: > > 1> There is a code in Oracle like > > Type Tstate is table of number(9) > index by binary_integer; > ........ > To define a runtime table, basically it works like a array, How can it > be possible in Postgres SQL, > I have tried create temp table.... But it not works.. > Is there any way to use arrays. It'd be much easier to help you if you posted the function/procedure you're trying to port. Just one line is harder. > 2> There is one function in Oracle Executesql '...........' to execute > and what i got in Postgres is Execute immediate '.........' > But it is giving error at Execute. Again, you're giving way too little detail. What error? What are you trying? Without this, it's very hard to help. -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 Cannot open CATFOOD.CAN - Eat logitech mouse instead (Y/n)?