Martijn :
OK, y try to explain.
First, y im using phppgAdmin for do this operations, becous my systems are
all web based.
My developpement plataform is windows, and this is the reason of use pg
8.0.4.
1) I change :
CREATE OR REPLACE FUNCTION LEFT( sTexto CHARACTER VARYING, nPosFin INTEGER )
for :
CREATE OR REPLACE FUNCTION LEFT( CHARACTER VARYING, INTEGER )
Becouse in the online documentation of pg 7.4 does not has other syntax for
parameters.
2)
RETURNS "varchar" AS $$ --> Syntax error here.
I change the function to
CREATE OR REPLACE FUNCTION LEFT( CHARACTER VARYING, INTEGER )
RETURNS "varchar"
LANGUAGE plpgsql
CALLED ON NULL INPUT
SECURITY INVOKER
AS '
BEGIN
IF sTexto IS NULL OR nPosFin IS NULL OR nPosFin <= 0 THEN
RETURN '';
ELSE
RETURN SUBSTR( sTexto, 1, nPosFin );
END IF;
END;
';
At this point i have sourprice. The hosting say does no exist 'plpgsql'
This last syntax has error, but i can't find.
Can you help me ?
Alejandro MSG <[EMAIL PROTECTED]>
Porto Alegre
Brasil
-->-----Mensagem original-----
-->De: [EMAIL PROTECTED]
-->[mailto:[EMAIL PROTECTED] Em nome de
-->Martijn van Oosterhout
-->Enviada em: domingo, 14 de maio de 2006 10:38
-->Para: Alejandro Michelin Salomon ( Adinet )
-->Cc: Pgsql-General
-->Assunto: Re: [GENERAL] Diferences between functions criated
-->in pg 8.0.4 and criated in pg 7.4.8
-->
-->
-->On Sun, May 14, 2006 at 10:10:44AM -0300, Alejandro Michelin
-->Salomon ( Adinet ) wrote:
-->> Hi :
-->>
-->> I criated some function in my pg 8.0.4, they function as spected.
-->>
-->> But when i try tu criate this functions in my hosting that has pg
-->> 7.4.8, i can not do. I read documentation an i see some
-->disferences.
-->
--><snip>
-->
-->> How i need change, to get this function runing in pg 7.4.8 ?
-->
-->Well, since you havn't told us the error message it's hard
-->to tell the problem. At a guess though, 7.4 doesn't
-->understand dollar-quoting.
-->
-->Have a nice day,
-->--
-->Martijn van Oosterhout <kleptog@svana.org>
-->http://svana.org/kleptog/
-->> From each according to his ability. To each according to
-->his ability
-->> to litigate.
-->
-->--
-->No virus found in this incoming message.
-->Checked by AVG Free Edition.
-->Version: 7.1.392 / Virus Database: 268.5.6/339 - Release
-->Date: 14/5/2006
-->
-->
-->
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.5.6/339 - Release Date: 14/5/2006
--
No virus found in this outgoing message.
Checked by AVG Free Edition.
Version: 7.1.392 / Virus Database: 268.5.6/339 - Release Date: 14/5/2006
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
