pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedProblems in porting from Oracle to Postgres
2+ messages / 2 participants
[nested] [flat]
* Problems in porting from Oracle to Postgres
@ 2001-05-11 06:54 Amit <amitsaxena178@rediffmail.com>
2001-05-11 15:06 ` Re: [HACKERS] Problems in porting from Oracle to Postgres Roberto Mello <rmello@cc.usu.edu>
0 siblings, 1 reply; 2+ messages in thread
From: Amit @ 2001-05-11 06:54 UTC (permalink / raw)
To: pgsql-hackers@postgresql.org
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 )
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: [HACKERS] Problems in porting from Oracle to Postgres
2001-05-11 06:54 Problems in porting from Oracle to Postgres Amit <amitsaxena178@rediffmail.com>
@ 2001-05-11 15:06 ` Roberto Mello <rmello@cc.usu.edu>
0 siblings, 0 replies; 2+ messages in thread
From: Roberto Mello @ 2001-05-11 15:06 UTC (permalink / raw)
To: Amit <amitsaxena178@rediffmail.com>; +Cc: pgsql-sql
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.net
http://www.sdl.usu.edu - Space Dynamics Lab, Developer
Cannot open CATFOOD.CAN - Eat logitech mouse instead (Y/n)?
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2001-05-11 15:06 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2001-05-11 06:54 Problems in porting from Oracle to Postgres Amit <amitsaxena178@rediffmail.com>
2001-05-11 15:06 ` Roberto Mello <rmello@cc.usu.edu>
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