I there, I don't know what is happening. I can't run any of my functions. I
can make but i can't run it. but I can run my trigger functions. what might
be the problem, bad installation??

I run this example function

CREATE FUNCTION add_one (integer) RETURNS INTEGER AS '
BEGIN
RETURN $1 + 1;
END;
' LANGUAGE 'plpgsql';

and when I run add_one(2) i get this error

ERROR: syntax error at or near "add_one" at character 1
LINE 1: add_one(int 1);

can you help please!thanks in advance

_________________________________________________________________
FREE pop-up blocking with the new MSN Toolbar - get it now!
http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/

Search Discussions

  • Luis Silva at Jan 2, 2006 at 3:23 pm
    sorry I was stupid
    forgot the select

    _________________________________________________________________
    FREE pop-up blocking with the new MSN Toolbar - get it now!
    http://toolbar.msn.click-url.com/go/onm00200415ave/direct/01/

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-novice @
categoriespostgresql
postedJan 2, '06 at 3:19p
activeJan 2, '06 at 3:23p
posts2
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

Luis Silva: 2 posts

People

Translate

site design / logo © 2022 Grokbase