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?
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
--
Shoaib Mir
http://shoaibmir.wordpress.com/
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 removing the '/' at the start of the line.
Alban Hertroys
--
Screwing up is an excellent way to attach something to the ceiling.
!DSPAM:737,4c00decd10151812910245!