On Thu, Jul 30, 2009 at 12:22:03PM +0100, Andre Lopes wrote:
> Hi. I need to know what is wrong with this function
>
> CREATE OR REPLACE FUNCTION "public"."apr_alta_empregado" ("pID_SOCIEDADE"
> varchar, "pID_EMPREGADO" varchar, "pNOME" varchar, "pNOME_ABREV" varchar,
[..]
> VALUES ( pID_SOCIEDAD
Hello
don't use COMMIT in plpgsql. Plpgsql doesn't support it.
regards
Pavel Stehule
2009/7/30 Andre Lopes :
> Hi. I need to know what is wrong with this function
>
> [code]
> CREATE OR REPLACE FUNCTION "public"."apr_alta_empregado" ("pID_SOCIEDADE"
> varchar, "pID_EMPREGADO" varchar, "pNOME" va
Hi. I need to know what is wrong with this function
[code]
CREATE OR REPLACE FUNCTION "public"."apr_alta_empregado" ("pID_SOCIEDADE"
varchar, "pID_EMPREGADO" varchar, "pNOME" varchar, "pNOME_ABREV" varchar,
"pDAT_NASC" date, "pLOCALIDADE_NASC" varchar,
"pID_TIPO_BILHETE_IDENTIFICACAO" varchar, "pB
