Adrian : I make some changes, based in documentation that i find in the web, and i have this error : ERROR: language "plpgsql" does not exist Seems this guys does not put pg/plsql in the instalation. I have a question, is not pg/plsql core part in postgresql? If not is core funcionality, is not time to be pg/plsql part off the core. Postgresql without pg/plsql instaled, is like a Oracle without pl/sql. Thanks for help. Alejandro MSG <alejmsg@xxxxxxxxxxxxx> Porto Alegre Brasil -->-----Mensagem original----- -->De: Adrian Klaver [mailto:aklaver@xxxxxxxxxxx] -->Enviada em: domingo, 14 de maio de 2006 11:50 -->Para: pgsql-general@xxxxxxxxxxxxxx -->Cc: Alejandro Michelin Salomon ( Adinet ); 'Martijn van Oosterhout' -->Assunto: Re: RES: [GENERAL] Diferences between functions -->criated in pg 8.0.4 and criated in pg 7.4.8 --> --> -->The first thing to check is whether the hosting service has -->installed PL/pgsql -->as a language. If you have sufficient privileges you could -->try 'select -->lanname from pg_languages' to see if it is installed. -->On Sunday 14 May 2006 07:08 am, Alejandro Michelin Salomon ( -->Adinet ) wrote: -->> 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 <alejmsg@xxxxxxxxxxxxx> -->> Porto Alegre -->> Brasil -->> -->> -->> -->-----Mensagem original----- -->> -->De: pgsql-general-owner@xxxxxxxxxxxxxx -->> -->[mailto:pgsql-general-owner@xxxxxxxxxxxxxx] 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@xxxxxxxxx> -->> -->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 -->> --> -->> --> -->> --> --> -->-- -->Adrian Klaver -->aklaver@xxxxxxxxxxx --> --> -->-- -->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 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
