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 :
exception
if not found then null;
but it seems not to be correct, can anybody give me a hand? thanks
Rafael
_________________________________________________________________
Acepta el reto MSN Premium: Protección para tus hijos en internet.
Descárgalo y pruébalo 2 meses gratis.
http://join.msn.com?XAPID=1697&DI=1055&HL=Footer_mailsenviados_proteccioninfantil