Thread

Problems in porting from Oracle to Postgres

Amit <amitsaxena178@rediffmail.com> — 2001-05-11T06:54:25Z

Hi!
I am facing two problems in porting from oracle to Postgres SQL.

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.


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.

I will be very thankful if any one help me.

  Amit
( India )

Re: [HACKERS] Problems in porting from Oracle to Postgres

Roberto Mello <rmello@cc.usu.edu> — 2001-05-11T15:06:05Z

	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)?