Stored Procedure anlegen/löschen
| ID | 275 |
|---|---|
| Link Reference | Not set |
| Link Credits | Not set |
| Link Technical Documentation | Not set |
| PlCodelang | PL/pgSQL |
| PlGroup | Datenbank |
| PlItemTitle | Stored Procedure anlegen/löschen |
| Code | CREATE OR REPLACE FUNCTION increment(i INT) RETURNS void AS $$ BEGIN INSERT INTO accounts (id,name, balance) VALUES (i, 'Test', 1200); END; $$ LANGUAGE plpgsql; DROP FUNCTION increment(i INT); |
| Result Example | CREATE FUNCTION DROP FUNCTION |