From: Jean-Michel Chabanne <jeanmichel.chabanne@free.fr>
To: shyamperi@davlin.co.in
Cc: pgsql-admin@postgresql.org
Cc: pgsql-sql@postgresql.org
Subject: Re: Error with functions
Date: Sat, 20 Sep 2003 09:29:24 +0200
Message-ID: <3F6C01D4.7090000@free.fr> (raw)
In-Reply-To: <2753631.1064039518784.JavaMail.tomcat@mail.davlin.co.in>
References: <2753631.1064039518784.JavaMail.tomcat@mail.davlin.co.in>
shyamperi@davlin.co.in a écrit :
>Hey,
>create or replace function sample(varchar,int) returns varchar as'
>declare
> data alias for $1;
> size alias for $2;
>begin
> return substr(data,(length(data)-size)+1,length(data));
>end;
>' language 'plpgsql';
>____________________________
>WARNING: plpgsql: ERROR during compile of sample near line 2
>ERROR: parse error at or near ";"
>
>Can any body tell me why is this error coming
>-----
>Warm Regards
>Shÿam Peri
>
>II Floor, Punja Building,
>M.G.Road,
>Ballalbagh,
>Mangalore-575003
>Ph : 91-824-2451001/5
>Fax : 91-824-2451050
>
>
>DISCLAIMER: This message contains privileged and confidential information and is
>intended only for the individual named.If you are not the intended
>recipient you should not disseminate,distribute,store,print, copy or
>deliver this message.Please notify the sender immediately by e-mail if
>you have received this e-mail by mistake and delete this e-mail from
>your system.
>
>
> ------------------------------------------------------------------------
>
> Hey,
> create or replace function sample(varchar,int) returns varchar as'
> declare
> data alias for $1;
> size alias for $2;
> begin
> return substr(data,(length(data)-size)+1,length(data));
> end;
> ' language 'plpgsql';
>
> ____________________________
> WARNING: plpgsql: ERROR during compile of sample near line 2
> ERROR: parse error at or near ";"
>
> Can any body tell me why is this error coming
>
>-----
>Warm Regards
>Shÿam Peri
>
>II Floor, Punja Building,
>M.G.Road,
>Ballalbagh,
>Mangalore-575003
>Ph : 91-824-2451001/5
>Fax : 91-824-2451050
>
>
>
>
>
>
> * DISCLAIMER: This message contains privileged and confidential
> information and is intended only for the individual named.If you are
> not the intended recipient you should not
> disseminate,distribute,store,print, copy or deliver this
> message.Please notify the sender immediately by e-mail if you have
> received this e-mail by mistake and delete this e-mail from your system.*
>
>------------------------------------------------------------------------
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>
>
Hi,
I juste did a copy/paste of your sample on my test DB. I didn't get any
error message and the function works fine.
I run PostgreSQL 7.3.3
--
Jean-Michel Chabanne
77450 MONTRY (FRANCE)
48" 54' N - 2" 49' E
Powered by Linux
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jeanmichel.chabanne@free.fr, shyamperi@davlin.co.in, pgsql-admin@postgresql.org
Subject: Re: Error with functions
In-Reply-To: <3F6C01D4.7090000@free.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox