Problem in Porting from Oracle to Postgres SQl

From: Amit <amitsaxena178(at)rediffmail(dot)com>
To: pgsql-sql(at)postgresql(dot)org
Subject: Problem in Porting from Oracle to Postgres SQl
Date: 2001-05-10 11:52:56
Message-ID: 3AFA8118.FB0400BC@rediffmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 )

Browse pgsql-sql by date

  From Date Subject
Next Message Hervé Piedvache 2001-05-10 18:37:49 Order by email address by domain ?
Previous Message Markus Wagner 2001-05-10 10:41:09 postmaster admin questions