Problem in Porting from Oracle to Postgres SQl - Mailing list pgsql-sql

From Amit
Subject Problem in Porting from Oracle to Postgres SQl
Date
Msg-id 3AFA8118.FB0400BC@rediffmail.com
Whole thread Raw
List pgsql-sql
Hi! <p>I am facing two problems in porting from oracle to Postgres SQL. <p>1> There is a code in Oracle like
<p> <b>Type Tstate is table of number(9)</b><br /><b>    index by binary_integer;</b><br />. <br />........ <br />To
definea runtime table, basically it works like a array, How can it be possible in Postgres SQL, <br />I have tried
<b>createtemp table.</b>... But it not works.. <br />Is there any way to use arrays. <br />  <p>2> There is one
functionin Oracle <b>Executesql '...........'</b> to execute <br />    and what i got in Postgres is <b>Execute
immediate'.........'</b><br />    But it is giving error at Execute. <p>I will be very thankful if any one help me.
<p> Amit <br />( India ) 

pgsql-sql by date:

Previous
From: "Sylte"
Date:
Subject: Informix->PostgreSQL database convertion
Next
From: "Jack"
Date:
Subject: execute client application from PL/pgSql