PostgreSQL/ストアドプãƒã‚·ãƒ¼ã‚¸ãƒ£/ãƒ•ã‚¡ãƒ³ã‚¯ã‚·ãƒ§ãƒ³ä½œæˆ - yanor.net/wikiãƒ•ã‚¡ãƒ³ã‚¯ã‚·ãƒ§ãƒ³ä½œæˆ ä½œæˆ CREATE OR REPLACE FUNCTION myfunc(num int) RETURNS int AS $$ DECLARE ret int; BEGIN ret = num + 1; RETURN ret; END; $$ LANGUAGE plpgsql; 利用 SELECT myfunc( 100 ); ç¢ºèª SELECT proname, prosrc FROM pg_proc WHERE proname = 'myfunc'; 削除 DROP FUNCTION myfunc( int ); å‚考 http://www.postgresql.jp/document/9.1/html/plpgsql.html 2024-12-28 Git/GitHub/URLを変ãˆã‚‹ã“ã¨ãªãアカウントã”ã¨ã«SSHã‚ーを使ã„分ã‘ã‚‹ 2023-11-03 Windo
PostgreSQL備忘録 - Qiita
{{#tags}}- {{label}}
{{/tags}}