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