Thread: sintax error in script

CREATE OR REPLACE FUNCTION to_number(integer)
  RETURNS "numeric" AS
$BODY$
BEGIN
RETURN to_number($1, 'S99999999999999D999999');
EXCEPTION
  WHEN OTHERS THEN
    RETURN NULL;
END;
$BODY$
  LANGUAGE 'plpgsql' IMMUTABLE;
/-- END


pgsql is telling me /-- END has a sintax error,
just to confirm, is it okay if i get rid of that line?

Le vendredi 28 mai 2010 20:34:13, Shoaib Mir a écrit :
> On Sat, May 29, 2010 at 11:09 AM, Luis Daniel Lucio Quiroz <
>
> luis.daniel.lucio@gmail.com> wrote:
> > pgsql is telling me /-- END has a sintax error,
> > just to confirm, is it okay if i get rid of that line?
>
> I think you should be fine removing this, as if I re-call I haven't seen
> something like this in PLPSQL functions myself
thanx

On 29 May 2010, at 3:09, Luis Daniel Lucio Quiroz wrote:

> pgsql is telling me /-- END has a sintax error,
> just to confirm, is it okay if i get rid of that line?


Yes, that's a syntax error alright, what did you intend to write there? A comment maybe? You should be fine just
removingthe '/' at the start of the line. 

Alban Hertroys

--
Screwing up is an excellent way to attach something to the ceiling.


!DSPAM:737,4c00decd10151812910245!