AnantLabs / codesmith

Automatically exported from code.google.com/p/codesmith
1 stars 0 forks source link

Add Stored Procedure Support for Postgre #535

Open GoogleCodeExporter opened 9 years ago

GoogleCodeExporter commented 9 years ago
CREATE OR REPLACE FUNCTION My_Application_StoredProcedure(p_id integer, p_name 
character varying)
  RETURNS integer AS
$BODY$
BEGIN
INSERT INTO My_Application(
            id, name)
    values(p_id, p_name, LOCALTIMESTAMP);
return 1;
END;
   $BODY$
  LANGUAGE plpgsql VOLATILE

Original issue reported on code.google.com by bniemyjski on 2 Dec 2010 at 8:44