Hi, Could anybody please assist me how to start with PostgreSQL Stored Procedure and how to right it. Thanks Noufal
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;