From: Roberto Mello <rmello@cc.usu.edu>
To: Amit <amitsaxena178@rediffmail.com>
Cc: pgsql-sql@postgresql.org
Subject: Re: [HACKERS] Problems in porting from Oracle to Postgres
Date: Fri, 11 May 2001 09:06:05 -0600
Message-ID: <20010511090605.A19164@cc.usu.edu> (raw)
In-Reply-To: <3AFB8CA1.5B1055B1@rediffmail.com>
References: <3AFB8CA1.5B1055B1@rediffmail.com>
This is more appropriate for the pgsql-sql list, so im forwarding it
that way. The hackers list is for other purposes.
On Fri, May 11, 2001 at 12:24:25PM +0530, Amit wrote:
>
> 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.
It'd be much easier to help you if you posted the function/procedure
you're trying to port. Just one line is harder.
> 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.
Again, you're giving way too little detail. What error? What are you
trying? Without this, it's very hard to help.
-Roberto
--
+----| http://fslc.usu.edu USU Free Software & GNU/Linux Club |------+
Roberto Mello - Computer Science, USU - http://www.brasileiro.nethttp://www.sdl.usu.edu - Space Dynamics Lab, Developer
Cannot open CATFOOD.CAN - Eat logitech mouse instead (Y/n)?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: rmello@cc.usu.edu, amitsaxena178@rediffmail.com
Subject: Re: [HACKERS] Problems in porting from Oracle to Postgres
In-Reply-To: <20010511090605.A19164@cc.usu.edu>
References: <3AFB8CA1.5B1055B1@rediffmail.com> <20010511090605.A19164@cc.usu.edu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox