Learn PostgreSQL Stored Procedure

Hi,

Could anybody please assist me how to start with PostgreSQL Stored Procedure and how to right it.

Thanks

Noufal

 

http://www.postgresql.org/docs/

 

Postgresql has functions.

CREATE OR REPLACE FUNCTION function_name(in p_name varchar(25)) RETURNS numeric AS $$
DELCARE
v_id numeric;
BEGIN
select id into v_id from employee where name=p_name;
RETURN v_id;
END;
$$ LANGUAGE plpgsql;