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


---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

              http://archives.postgresql.org

Reply via email to