PostgreSQL �� PL/pgSQL ���̃\�[�X���m�F����
PostgreSQL �Ɋi�[����Ă��� PL/pgSQL ���̃\�[�X���m�F���郁���ł��B
���� test �Ƃ������Ŋm�F���Ă݂܂��B
CREATE OR REPLACE FUNCTION test(f1 TEXT, f2 TEXT) RETURNS TEXT AS $$ DECLARE BEGIN RETURN 'This is a pen!'; END; $$ LANGUAGE PLPGSQL;
���̏�i�[����Ă��� pg_proc �J�^���O����擾���܂��B prosrc ��Ƀ\�[�X���i�[����Ă��܂��B
db=# SELECT prosrc FROM pg_proc WHERE proname = 'test'; prosrc ------------------------------ DECLARE BEGIN RETURN 'This is a pen!'; END; (1 row)
pg_proc �J�^���O�ɂ� ���ɂ��F�X�ȏ�i�[����Ă��܂��B
db=# \x db=# SELECT * FROM pg_proc WHERE proname = 'test'; -[ RECORD 1 ]--+----------------------------- proname | test pronamespace | 27944 proowner | 16384 prolang | 34946 procost | 100 prorows | 0 proisagg | f prosecdef | f proisstrict | f proretset | f provolatile | v pronargs | 2 prorettype | 25 proargtypes | 25 25 proallargtypes | proargmodes | proargnames | {f1,f2} prosrc | : DECLARE : BEGIN : RETURN 'This is a pen!'; : END; : probin | - proconfig | proacl |
proargnames �������̖��O�� proargtypes �������̃f�[�^�^�ł��B prorettype �͖߂�l�̃f�[�^�^�ł��B
�y�Q�l�T�C�g�z
PostgreSQL 8.1.0 ���� 41.24. pg_proc
�� LPIC �����Z�~�i�[
�܂����������̏��ŁA���ȊO�̕��ɂ̓A���Ȃ̂ł��� 7 ���� LPIC �̖����Z�~�i�[�� 2 ����܂��B
�w LPIC ���x�� 1 �Z�p��������Z�~�i�[�x
7/11 ���
�wLPIC���x��1�Z�p��������Z�~�i�[�x�J�Á����i7��11���j�̂��m�点�bLinux�Z�p�ҔF��@�ց@LPI-Japan
