Help with functions

"Patrick Bye (WFF)" <PBYE@Westfair.CA> writes:

CREATE FUNCTION getprice(text, text, text, text) RETURNS float8 AS 'DECLARE
v_itemnum ALIAS FOR $1;
v_custnum ALIAS FOR $2;
v_pcid ALIAS FOR $3;
v_branch ALIAS FOR $4;
BEGIN
RETURN 0;
END getprice;
' LANGUAGE 'plpgsql';

Try changing the `END getprice;' to just `END;' like the examples in
the manual. Note that the error message should have pointed you to
the specific line in the function where this error lay (with lines
counting from the beginning of the function, not the file).

--
Brandon Craig Rhodes http://www.rhodesmill.org/brandon
Georgia Tech brandon@oit.gatech.edu

Jast remove the name of the function alter END

wrong: END getprice;

ritgh: END;

Cristian

----- Original Message -----
From: "Patrick Bye (WFF)" <PBYE@Westfair.CA>
To: <pgsql-general@postgresql.org>
Sent: Monday, March 03, 2003 7:20 PM
Subject: [GENERAL] Help with functions

I'm having trouble trying to create a function. I'm new to functions and
I'm trying to figure them out but I can't even get something simple like
this to work. I believe I should be able to do 'SELECT getprice('text1',
'text2', 'text3', 'text4') as price' but all I get in PGAdmin tool is syntax
error near getprice. Is my SELECT statement wrong or my function. I did a
createlang on plpgsql before I started. I'm running 7.2.4.

CREATE FUNCTION getprice(text, text, text, text) RETURNS float8 AS 'DECLARE
v_itemnum ALIAS FOR $1;
v_custnum ALIAS FOR $2;
v_pcid ALIAS FOR $3;
v_branch ALIAS FOR $4;
BEGIN
RETURN 0;
END getprice;

' LANGUAGE 'plpgsql';

Patrick Bye
Programmer / Analyst
Westfair Foods Ltd.
pbye@westfair.ca
(403) 291-6538

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/users-lounge/docs/faq.html