From: Senthil <senthil.kandaswamy@mobax.com>
To: pgsql-sql@postgresql.org
Subject: Doubts porting from Oracle to postgresql
Date: Mon, 30 Dec 2002 13:52:13 +0530
Message-ID: <003301c2afdc$96057080$67cac9c8@mobax.com> (raw)
Hai everybody,
Hai,
Currently, I'm at the work of converting database from Oracle to Postgresql.
I have some doubts:
1) What is the equivalent of Oracle ROWNUM in Postgresql? If there is no such equivalent, can U give me an idea about that?
2) How to replace stored procedures with many OUT parameters? I want to call the procedure from Java code.
Please tell me the way to return the values of OUT parameters returned previously by Oracle, from the plpgsql code.
It's very urgent. Please reply quickly with some code examples.
HOW to handle the values returned by the Oracle OUT parameters, in Postgresql?
i.e, how to return the Oracle OUT parameters' values to the calling Java code, in postgresql.
If anybody knows, please explain with suitable examples with plpgsql code and also the Calling Java code.
3) Can default values be assigned to postgresql function parameters? If yes, how?
Thanks in advance.
Senthil.
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 using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: senthil.kandaswamy@mobax.com
Subject: Re: Doubts porting from Oracle to postgresql
In-Reply-To: <003301c2afdc$96057080$67cac9c8@mobax.com>
* 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