Problems in porting from Oracle to Postgres

From: Amit <amitsaxena178(at)rediffmail(dot)com>
To: pgsql-hackers(at)postgresql(dot)org
Subject: Problems in porting from Oracle to Postgres
Date: 2001-05-11 06:54:25
Message-ID: 3AFB8CA1.5B1055B1@rediffmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-sql

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 )

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Klaus Reger 2001-05-11 08:48:38 Re: Converting PL/SQL to PL/PGSQL
Previous Message Tom Lane 2001-05-11 05:28:22 Re: 7.1.2 release

Browse pgsql-sql by date

  From Date Subject
Next Message Maxim Maletsky 2001-05-11 07:45:26 RE: Order by email address by domain ?
Previous Message Lajtos Mate 2001-05-11 06:48:01 Postgres function library