Skip site navigation (1) Skip section navigation (2)

Error en phpPgAdmin

From: "Jorge Diaz" <jorge(dot)diaz(dot)t(at)gmail(dot)com>
To: pgsql-es-ayuda(at)postgresql(dot)org
Subject: Error en phpPgAdmin
Date: 2008-07-30 15:59:50
Message-ID: e59bc1180807300859nd912af6i774576f2781f8790@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-es-ayuda
*Buenos Dias:*
EL mismo codigo lo probe en un pgAdmin III y funciona de lo mas normal, pero
en phpPgAdmin me emite este mensaje... de antemano muchas gracias por la
ayuda que me puedan brindar.


*SQL error:*

ERROR:  syntax error at or near "CREATE" at character 32

 *In statement:*

SELECT COUNT(*) AS total FROM (CREATE OR REPLACE FUNCTION
"public"."sp_nueprofesor" () RETURNS char AS
$body$
DECLARE
cod_nue char(5);
aux char(20);
BEGIN
	select into cod_nue max(procod) from profesor;
	if cod_nue is null then
	  cod_nue='00001';
	else
	  aux='00000'|| cast((cast(cod_nue as int4)+1) as char(5));
	  cod_nue=substr(aux,length(aux)-1,5);
	end if;
return cod_nue;
END;
$body$
LANGUAGE 'plpgsql' VOLATILE CALLED ON NULL INPUT SECURITY INVOKER) AS sub


Atte
*Jorge Diaz*

Responses

pgsql-es-ayuda by date

Next:From: Rodriguez FernandoDate: 2008-07-30 16:29:59
Subject: Re: conectar desde Java
Previous:From: Gabriel FerroDate: 2008-07-30 15:56:08
Subject: conectar desde Java

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group