| From: | "Luis Silva" <lfs12(at)hotmail(dot)com> |
|---|---|
| To: | pgsql-novice(at)postgresql(dot)org |
| Subject: | function problem |
| Date: | 2006-01-02 15:19:37 |
| Message-ID: | BAY18-F42278188FBEBBB31CEADCB52D0@phx.gbl |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-novice |
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/
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luis Silva | 2006-01-02 15:23:39 | Re: function problem |
| Previous Message | Frank Bax | 2006-01-02 14:49:32 | Re: backup by schema |