PostgreSQL Stored Procedures

1 stored procedures that return result sets

--Drop FUNCTION getall ();
CREATE or REPLACE FUNCTION getall ()
RETURNS Setof users as
$BODY $
SELECT * from users;
$BODY $
Language SQL; --The SQL used here

2 stored procedures that return a single value

--Drop FUNCTION adduser2 (CHARACTER VARYING);
CREATE or REPLACE FUNCTION adduser2 (usernamezll varchar)
RETURNS Int2 as
$body $
BEGIN
Insert into users (username) VALUES (USERNAMEZLL);
RETURN 5;
End
$body $
Language plpgsql; --Plpgsql is used here.

PostgreSQL Stored Procedures