| 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: | Whole Thread | Raw Message | 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 |