Problem in Porting from Oracle to Postgres

From: Amit <amitsaxena178(at)rediffmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Problem in Porting from Oracle to Postgres
Date: 2001-05-11 05:47:22
Message-ID: 3AFB7CEA.2C2E46EF@rediffmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

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 )

Browse pgsql-bugs by date

  From Date Subject
Next Message pgsql-bugs 2001-05-11 09:32:43 Irix build failes (PSQL 7.1.1)
Previous Message Tom Lane 2001-05-10 21:50:50 Re: order by using functions under unions