[PostgreSQL] CREATE FUNCTION Sample Source

scott@pg-00:5432:scottdb] 

SQL> CREATE FUNCTION oneplus(int) RETURNS int AS '

BEGIN

RETURN $1 + 1;

END;

' LANGUAGE 'plpgsql';

CREATE FUNCTION

Time: 13.292 ms

scott@pg-00:5432:scottdb] 

SQL> select oneplus(100);

 oneplus 

---------

     101

(1 row)

Time: 35.835 ms

scott@pg-00:5432:scottdb] 

SQL> SELECT prosrc FROM pg_proc WHERE proname='oneplus';  # 딕션너리에 소스가 저장됩니다.

     prosrc     

----------------

               +

 BEGIN         +

 RETURN $1 + 1;+

 END;          +

 

(1 row)

Time: 5.376 ms

scott@pg-00:5432:scottdb] 

SQL> drop function oneplus(int);   ## drop 시에 인자까지 넣어야 합니다. 주의!

DROP FUNCTION

Time: 6.277 ms

scott@pg-00:5432:scottdb] 

SQL> SELECT prosrc FROM pg_proc WHERE proname='oneplus';

 prosrc 

--------

(0 rows)

Time: 1.232 ms

scott@pg-00:5432:scottdb]