Hi,
I am converting oracle stored procedures to plpgsql. There are several
of the oracle procedures where a parameter vCommit is passed into the
procedure and:
if vCommit = 1
then
commit;
do_something_commit(vdate);
else
do_something(vdate);
end if;
does this make sense i
Hi,
I am converting oracle stored procedures to plpgsql. There are several
of the oracle procedures where a parameter vCommit is passed into the
procedure and:
if vCommit = 1
then
commit;
do_something_commit(vdate);
else
do_something(vdate);
end if;
does this make s
Hi,
Once again I'm translating an oracle stored proc that uses a global
temporary table. Using postgresql's nonglobal temp tables from plpgsql
functions is painful - translating all the queries into strings passed
to execute. It is error prone, and it makes the queries less readable,
thus less
may need to be rewritten if they use the Oracle syntax for outer
joins. Also the NVL function can be replaced with coalesce and DECODE
will need to be rewritten with CASE.
SYSDATE can be replaced with NOW()
Also check out this doc for more hints:
http://www-2.cs.cmu.edu/~pmerson/docs/OracleToPost
ting from TSQL to
PL/pgSQL, but then I've not looked for any. They may exist.
Best of luck,
Dennis Sacks
[EMAIL PROTECTED]
you'll want to run vacuum analyze.
Dennis Sacks
[EMAIL PROTECTED]
Bruno Wolff III wrote:
On Tue, Jan 25, 2005 at 21:21:08 -0700,
Dennis Sacks <[EMAIL PROTECTED]> wrote:
One of the things you'll want to do regularly is run a "vacuum analyze".
You can read up on this in the postgresql docs. This is essential to the
indexes being use
filesystem (which is what filesystems are designed for) and store the
metadata in the database.
Dennis Sacks
[EMAIL PROTECTED]
---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command
imited text
to be indexed & searched.
Dennis Sacks
[EMAIL PROTECTED]
