Problem in Porting from Oracle to Postgres SQl

Поиск
Список
Период
Сортировка
От Amit
Тема Problem in Porting from Oracle to Postgres SQl
Дата
Msg-id 3AFA8118.FB0400BC@rediffmail.com
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: "Sylte"
Дата:
Сообщение: Informix->PostgreSQL database convertion
Следующее
От: "Jack"
Дата:
Сообщение: execute client application from PL/pgSql