I have this statement in oracle:
CREATE OR REPLACE TRIGGER trig
AFTER INSERT OR UPDATE OR DELETE OF column2 <<- Here
is the doubt
ON table_product
FOR EACH ROW
BEGIN
...
END
Migrating to PostgreSQL, the conditionals for AFTER UPDATE OF COLUMN2 in
ave to write many else options in this way?
select case when pre.C_EST = '01' THEN 'U'
ELSE when pre-C_EST = '02' THEN 'M'
...
END AS EST
Rafael
From: Oliver Elphick
Reply-To: olly@lfix.co.uk
To: Rafael Montoya <[EMAIL PROTECTED]>
CC:
I'm migrating from oracle to postgresl, and i have these 2 problems:
1.
PostgreSQL doesn't support function DECODE from Oracle, but it can be
replicated with
CASE WHEN expr THEN expr [...] ELSE expr END , the problem appears when i
want to convert this sentence from oracle to postgresl:
I need to know if there is a tool that convert oracle procedures and
triggers to plpgsql syntax. Please, can anybody tell me where do i download
it from?, i'll thank you a lot.
Rafael
_
Un amor, una aventura, compañía para un via
This error is shown after choose the language in the installation of
Postgresql 8.0.3 in windows 2000:
"The installer has detected an incompatible version of OpenSSL installed in
your system PATH. PostgreSQL requires OpenSSL 0.9.7 or later. If you remove
your OpenSSL files (LIBEAY32.DLL and SS
I'm migrating some triggers from oracle to postgresql and i can´t find the
equivalent of the following two sentences:
1)
DECLARE
TMP_COD_PRO PRODUCT.COD_PRO%TYPE;
I don't know if its equivalent exists in PostgreSQL
2)
EXCEPTION
when no_data_found then null;
what i tried :
exceptio
; select load_exp();
or it isn't necessary?
Thanks again for your answers.
Rafael
From: Jaime Casanova <[EMAIL PROTECTED]>
Reply-To: Jaime Casanova <[EMAIL PROTECTED]>
To: Rafael Montoya <[EMAIL PROTECTED]>
CC: pgsql-general@postgresql.org
Subject: Re: [GENERAL] [General] Usi
Hi everybody, thanks for your answers about hardware requirements. DB design
was succesful and now we are migrating stored procedures from oracle to
PostgreSQL.
I can't handle cursors very well in PostgreSQL, for example, i need to
migrate this stored procedure:
CREATE OR REPLACE PROCEDURE LOA
swers.
Rafael Montoya
_
Un amor, una aventura, compañía para un viaje. Regístrate gratis en MSN Amor
& Amistad. http://match.msn.es/match/mt.cfm?pg=channel&tcid=162349
---(end
afael Montoya
From: Ben <[EMAIL PROTECTED]>
To: "Rafael Montoya" <[EMAIL PROTECTED]>
CC: pgsql-general@postgresql.org
Subject: Re: [GENERAL] Hardware requirements
Date: Wed, 28 Sep 2005 23:30:06 -0700
Unless you need all that data in ram (and you probably don't), then
swers.
Rafael Montoya
_
Dale rienda suelta a tu tiempo libre. Encuentra mil ideas para exprimir tu
ocio con MSN Entretenimiento. http://entretenimiento.msn.es/
---(end of broadcast)---
11 matches
Mail list logo
