Problems in porting from Oracle to Postgres
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 )
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)?