锟斤拷锟叫讹拷锟矫诧拷锟角碉拷前"锟芥本 1"锟接口ｏ拷锟斤拷锟节憋拷锟斤拷锟斤拷锟斤拷锟皆ｏ拷锟斤拷锟皆憋拷写锟侥猴拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷没锟斤拷锟斤拷锟侥癸拷锟斤拷锟斤拷锟斤拷锟叫的猴拷锟斤拷锟斤拷SQL 锟斤拷写锟侥猴拷锟斤拷锟皆硷拷使锟矫版本 0 锟斤拷锟斤拷锟斤拷锟斤拷锟皆接口的猴拷锟斤拷锟斤拷锟侥碉拷锟矫讹拷锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷指锟斤拷锟斤拷锟皆碉拷锟斤拷锟矫达拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫达拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷姆锟绞街达拷懈煤锟斤拷锟斤拷锟斤拷锟斤拷锟酵拷锟斤拷锟斤拷锟斤拷锟斤拷峁╋拷锟皆达拷谋锟斤拷锟斤拷锟斤拷鹿锟斤拷锟斤拷锟斤拷锟轿憋拷写一锟斤拷锟铰的癸拷锟斤拷锟斤拷锟皆碉拷锟矫达拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷
一锟斤拷锟斤拷锟斤拷锟斤拷锟皆的碉拷锟矫达拷锟斤拷锟斤拷锟斤拷一锟斤拷"锟斤拷锟斤拷锟斤拷"锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷一锟街憋拷锟斤拷锟斤拷锟斤拷锟皆ｏ拷锟斤拷 C锟斤拷锟斤拷写锟斤拷使锟矫版本-1锟接口诧拷锟斤拷锟斤拷PostgreSQL锟斤拷注锟斤拷为锟睫诧拷锟斤拷锟揭凤拷锟斤拷锟斤拷锟斤拷language_handler锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟轿憋拷锟斤拷捅锟绞讹拷煤锟斤拷锟斤拷锟揭伙拷锟斤拷锟斤拷么锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟街癸拷锟斤拷锟� SQL 锟斤拷锟斤拷锟叫憋拷直锟接碉拷锟矫★拷锟斤拷锟斤拷 C 锟斤拷锟皆碉拷锟矫癸拷锟斤拷锟酵讹拷态锟斤拷锟斤拷母锟斤拷锟较革拷冢锟斤拷锟斤拷锟斤拷 36.9 锟斤拷锟斤拷
锟斤拷锟矫达拷锟斤拷锟斤拷锟侥碉拷锟矫凤拷式锟斤拷锟斤拷锟斤拷锟轿何猴拷锟斤拷锟斤拷同锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷值锟斤拷锟叫关憋拷锟斤拷锟矫猴拷锟斤拷锟斤拷息锟斤拷FunctionCallInfoData 锟结构锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷Datum锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷希锟斤拷锟斤拷锟斤拷一锟斤拷 SQL 锟斤拷值锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟�FunctionCallInfoData锟结构锟斤拷isnull锟津）★拷一锟斤拷锟斤拷锟矫达拷锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷通锟斤拷锟斤拷锟矫猴拷锟斤拷之锟斤拷锟斤拷锟斤拷锟斤拷锟�FunctionCallInfoData锟结构锟斤拷flinfo->fn_oid锟津将帮拷锟斤拷要锟斤拷锟斤拷锟矫碉拷实锟绞猴拷锟斤拷锟斤拷 OID锟斤拷锟斤拷锟斤拷锟角碉拷锟矫达拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫达拷锟斤拷锟斤拷锟斤拷锟斤拷使锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟揭达拷锟斤拷母锟斤拷锟斤拷锟斤拷锟酵拷锟斤拷锟斤拷锟斤拷锟斤拷莸牟锟斤拷锟斤拷斜锟斤拷丫锟斤拷锟斤拷锟斤拷锟侥匡拷旰拷锟斤拷锟斤拷锟斤拷堑锟斤拷么锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷煤谩锟�
锟斤拷锟矫达拷锟斤拷锟斤拷锟斤拷锟斤拷锟�pg_proc系统目录锟斤拷取锟矫该猴拷锟斤拷锟斤拷锟筋并锟揭凤拷锟斤拷锟斤拷锟斤拷锟矫猴拷锟斤拷锟侥诧拷锟斤拷锟酵凤拷锟斤拷锟斤拷锟酵★拷锟矫猴拷锟斤拷锟斤拷CREATE FUNCTION锟斤拷锟斤拷锟�AS锟接撅拷锟斤拷锟斤拷锟�pg_proc锟叫碉拷prosrc锟斤拷锟叫憋拷锟揭碉拷锟斤拷通锟斤拷锟斤拷锟角癸拷锟斤拷锟斤拷锟斤拷锟叫碉拷源锟侥憋拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷某锟街讹拷锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷锟侥硷拷锟斤拷路锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟轿猴拷锟斤拷细锟斤拷锟竭碉拷锟矫达拷锟斤拷锟斤拷锟斤拷什么锟侥讹拷锟斤拷锟斤拷
同一锟斤拷锟斤拷锟斤拷锟斤拷每锟斤拷 SQL 锟斤拷锟斤拷锟叫筹拷锟斤拷锟斤拷锟斤拷锟矫讹拷巍锟揭伙拷锟斤拷锟斤拷么锟斤拷锟斤拷锟斤拷锟斤拷锟酵拷锟绞癸拷锟�flinfo->fn_extra锟斤拷锟斤拷锟斤拷锟斤拷锟截革拷锟斤拷锟揭癸拷锟节憋拷锟斤拷锟矫猴拷锟斤拷锟斤拷锟斤拷息锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷为NULL锟斤拷锟斤拷锟角匡拷锟皆憋拷锟斤拷锟矫达拷锟斤拷锟斤拷锟斤拷锟斤拷为指锟斤拷锟斤拷诒锟斤拷锟斤拷煤锟斤拷锟斤拷锟斤拷锟较拷锟斤拷诤锟斤拷锟斤拷锟斤拷锟斤拷校锟斤拷锟斤拷flinfo->fn_extra锟窖撅拷为锟斤拷-NULL锟斤拷锟斤拷锟斤拷锟斤拷锟皆憋拷使锟矫诧拷锟斤拷锟斤拷息锟斤拷锟揭诧拷锟借将锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟矫达拷锟斤拷锟斤拷锟斤拷锟斤拷确锟斤拷flinfo->fn_extra锟斤拷指锟斤拷直锟斤拷锟斤拷前锟斤拷询锟斤拷末尾锟斤拷锟斤拷锟斤拷锟节存，锟斤拷为一锟斤拷FmgrInfo锟斤拷锟捷接口匡拷锟皆憋拷锟斤拷锟斤拷锟斤拷么锟矫★拷一锟街凤拷式锟斤拷锟斤拷flinfo->fn_mcxt指锟斤拷锟斤拷锟节达拷锟斤拷锟斤拷锟斤拷锟叫凤拷锟斤拷锟斤拷锟斤拷锟斤拷锟捷ｏ拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷通锟斤拷锟斤拷锟斤拷锟斤拷FmgrInfo锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷同锟斤拷锟斤拷锟斤拷锟节★拷锟斤拷锟角达拷锟斤拷锟斤拷也锟斤拷锟斤拷选锟斤拷使锟斤拷一锟斤拷锟斤拷锟斤拷时锟斤拷锟斤拷锟斤拷锟斤拷诖锟斤拷锟斤拷锟斤拷模锟斤拷锟斤拷锟斤拷锟斤拷芄锟斤拷诓锟窖拷浠猴拷婧拷锟斤拷锟斤拷锟斤拷锟较拷锟�
锟斤拷一锟斤拷锟斤拷锟斤拷锟斤拷锟皆猴拷锟斤拷锟斤拷锟斤拷为一锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷时锟斤拷锟斤拷锟斤拷锟叫诧拷锟斤拷通锟斤拷锟斤拷锟矫凤拷式锟斤拷锟斤拷锟捷ｏ拷锟斤拷锟斤拷FunctionCallInfoData锟斤拷context锟斤拷指锟斤拷一锟斤拷TriggerData锟结构锟斤拷锟斤拷锟斤拷为NULL锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷通锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷锟皆达拷锟斤拷锟斤拷应锟斤拷为锟斤拷锟斤拷锟斤拷锟皆猴拷锟斤拷锟结供锟斤拷锟斤拷锟斤拷锟矫碉拷锟斤拷锟斤拷锟斤拷锟斤拷息锟斤拷
锟斤拷锟斤拷一锟斤拷锟斤拷 C 锟斤拷写锟侥癸拷锟斤拷锟斤拷锟皆达拷锟斤拷锟斤拷锟斤拷模锟藉：
#include "postgres.h"
#include "executor/spi.h"
#include "commands/trigger.h"
#include "fmgr.h"
#include "access/heapam.h"
#include "utils/syscache.h"
#include "catalog/pg_proc.h"
#include "catalog/pg_type.h"
#ifdef PG_MODULE_MAGIC
PG_MODULE_MAGIC;
#endif
PG_FUNCTION_INFO_V1(plsample_call_handler);
Datum
plsample_call_handler(PG_FUNCTION_ARGS)
{
Datum retval;
if (CALLED_AS_TRIGGER(fcinfo))
{
/*
* Called as a trigger procedure
*/
TriggerData *trigdata = (TriggerData *) fcinfo->context;
retval = ...
}
else
{
/*
* Called as a function
*/
retval = ...
}
return retval;
}要锟斤拷筛玫锟斤拷么锟斤拷锟斤拷锟斤拷锟街伙拷锟揭拷锟斤拷爰盖э拷写锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷偶锟斤拷伞锟�
锟节斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟揭伙拷锟斤拷锟斤拷锟斤拷锟侥ｏ拷椋�锟斤拷 36.9.6 锟斤拷锟斤拷锟襟，斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷注锟斤拷锟斤拷锟接癸拷锟斤拷锟斤拷锟皆ｏ拷
CREATE FUNCTION plsample_call_handler() RETURNS language_handler
AS 'filename'
LANGUAGE C;
CREATE LANGUAGE plsample
HANDLER plsample_call_handler;
锟斤拷锟斤拷锟结供一锟斤拷锟斤拷锟矫达拷锟斤拷锟斤拷锟斤拷锟节达拷锟斤拷一锟斤拷锟斤拷小锟斤拷锟斤拷锟斤拷锟斤拷锟窖撅拷锟姐够锟斤拷锟斤拷锟斤拷锟斤拷锟结供锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷选锟侥猴拷锟斤拷锟斤拷锟矫该猴拷锟斤拷锟斤拷锟斤拷锟矫★拷锟斤拷锟斤拷锟斤拷锟斤拷证锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷一锟斤拷锟斤拷证锟斤拷锟斤拷锟皆憋拷锟结供锟斤拷锟斤拷锟斤拷锟斤拷CREATE FUNCTION锟节硷拷锟斤拷锟斤拷锟斤拷锟斤拷锟截的硷拷椤Ｒ伙拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷员锟斤拷峁╋拷锟斤拷锟斤拷锟斤拷锟斤拷锟街э拷锟酵拷锟�DO锟斤拷锟斤拷执锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷椤�
锟斤拷锟揭伙拷锟斤拷锟街わ拷锟斤拷锟揭伙拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷峁╋拷锟斤拷锟斤拷锟斤拷氡伙拷锟斤拷锟轿伙拷锟斤拷锟斤拷锟揭伙拷锟斤拷锟揭�oid锟斤拷锟酵诧拷锟斤拷锟侥猴拷锟斤拷锟斤拷锟斤拷锟斤拷证锟斤拷锟侥斤拷锟斤拷锟斤拷锟斤拷裕锟斤拷锟轿拷锟酵拷锟斤拷锟斤拷锟斤拷锟轿拷锟斤拷锟�void锟斤拷锟斤拷证锟斤拷锟斤拷锟斤拷一锟斤拷锟窖撅拷锟斤拷锟斤拷锟剿伙拷锟斤拷锟斤拷锟揭伙拷锟斤拷愿霉锟斤拷锟斤拷锟斤拷员锟叫达拷暮锟斤拷锟斤拷锟�CREATE FUNCTION锟斤拷锟斤拷之锟襟被碉拷锟矫★拷锟斤拷锟斤拷锟斤拷锟� OID 锟角猴拷锟斤拷锟斤拷pg_proc锟叫碉拷 OID锟斤拷锟斤拷证锟斤拷锟斤拷锟斤拷锟斤拷通锟斤拷锟斤拷式取锟斤拷锟斤拷锟斤拷校锟斤拷锟斤拷锟斤拷锟斤拷魏魏锟斤拷实募锟介。锟斤拷锟饺ｏ拷锟斤拷锟斤拷CheckFunctionValidatorAccess()锟斤拷锟斤拷隙锟斤拷没锟酵拷锟�CREATE FUNCTION锟睫凤拷锟斤到锟斤拷锟斤拷证锟斤拷锟斤拷锟斤拷式锟斤拷锟矫★拷锟斤拷锟酵的硷拷锟斤拷锟斤拷锟斤拷证锟斤拷锟斤拷锟侥诧拷锟斤拷锟酵斤拷锟斤拷锟斤拷锟斤拷欠癖桓锟斤拷锟斤拷锟街э拷郑锟斤拷约锟斤拷煤锟斤拷锟斤拷锟斤拷诟锟斤拷锟斤拷锟斤拷锟斤拷锓拷欠锟斤拷锟饺凤拷锟斤拷锟斤拷锟斤拷证锟斤拷锟斤拷锟街该猴拷锟斤拷锟角好的ｏ拷锟斤拷应锟斤拷只锟角凤拷锟截★拷锟斤拷锟斤拷锟斤拷锟斤拷锟揭伙拷锟斤拷锟斤拷锟斤拷锟接︼拷锟酵拷锟酵拷锟斤拷锟�ereport()锟斤拷锟襟报革拷锟斤拷票锟斤拷锟矫达拷锟斤拷锟阶筹拷一锟斤拷锟斤拷锟斤拷强锟斤拷一锟斤拷锟斤拷锟斤拷毓锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷止锟斤拷锟斤拷确锟侥猴拷锟斤拷锟斤拷锟藉被锟结交锟斤拷
锟斤拷证锟斤拷锟斤拷锟斤拷通锟斤拷应锟斤拷锟斤拷锟斤拷check_function_bodies锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷乇锟斤拷锟矫达拷魏未锟斤拷鄞锟侥伙拷锟斤拷锟斤拷锟斤拷锟斤拷锟叫的硷拷锟接︼拷帽锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟结供锟剿憋拷锟斤拷时锟斤拷锟斤拷执锟叫ｏ拷锟斤拷证锟斤拷锟斤拷锟斤拷锟斤拷锟狡匡拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷执锟叫的硷拷椤ｏ拷乇锟截ｏ拷锟斤拷锟斤拷锟斤拷锟斤拷岜�pg_dump锟截闭ｏ拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷院锟斤拷锟斤拷锟斤拷锟斤拷玫锟斤拷母锟斤拷锟斤拷没锟斤拷锟叫╋拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟捷匡拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷为锟斤拷锟斤拷要锟襟，碉拷锟矫达拷锟斤拷锟斤拷应锟矫憋拷锟斤拷锟斤拷锟斤拷锟街わ拷锟斤拷丫锟斤拷锟斤拷锟斤拷丶锟斤拷锟斤拷煤锟斤拷锟斤拷锟接碉拷锟揭伙拷锟斤拷锟街わ拷锟斤拷锟揭拷悴伙拷锟斤拷玫锟斤拷么锟斤拷锟斤拷锟斤拷锟斤拷约锟介，锟斤拷锟斤拷锟斤拷锟斤拷锟揭伙拷锟�CREATE FUNCTION锟斤拷锟斤拷锟叫凤拷锟斤拷锟斤拷锟皆达拷锟斤拷时锟斤拷锟斤拷锟斤拷示锟矫伙拷锟斤拷锟斤拷然锟斤拷锟斤拷锟斤拷锟斤拷锟绞裁达拷锟窖★拷锟襟部分讹拷锟斤拷锟斤拷锟斤拷锟斤拷证锟斤拷锟斤拷锟斤拷锟斤拷注锟解当check_function_bodies为锟斤拷时锟斤拷锟斤拷锟斤拷CREATE FUNCTION锟斤拷锟斤拷只执锟叫革拷锟接碉拷一锟斤拷锟斤拷锟斤拷锟斤拷SET锟接句。 锟斤拷耍锟轿拷吮锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟揭伙拷锟阶拷锟绞憋拷锟轿笔э拷埽锟斤拷锟�check_function_bodies为锟截憋拷时锟斤拷锟斤拷锟斤拷锟斤拷芑岜� GUC 锟斤拷锟斤拷影锟斤拷募锟斤拷锟斤拷锟接︼拷锟斤拷锟斤拷锟斤拷锟斤拷锟�
锟斤拷锟揭伙拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷峁╋拷锟揭伙拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷氡伙拷锟斤拷锟轿伙拷锟斤拷锟斤拷锟揭伙拷锟斤拷锟揭�internal锟斤拷锟酵诧拷锟斤拷锟侥猴拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟侥斤拷锟斤拷岜伙拷锟斤拷裕锟斤拷锟斤拷锟斤拷通锟斤拷锟斤拷锟斤拷锟斤拷为锟斤拷锟斤拷void锟斤拷锟斤拷一锟斤拷DO锟斤拷浔伙拷锟斤拷锟街达拷锟街革拷锟斤拷锟斤拷锟斤拷锟斤拷锟绞憋拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷谩锟绞碉拷时锟斤拷锟斤拷莸牟锟斤拷锟斤拷锟揭伙拷锟街革拷锟揭伙拷锟�InlineCodeBlock锟结构锟斤拷指锟诫，锟斤拷锟斤拷锟斤拷锟叫癸拷DO锟斤拷锟斤拷锟斤拷锟侥讹拷锟斤拷息锟斤拷锟截憋拷锟角斤拷锟斤拷执锟叫碉拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟侥憋拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷应锟斤拷执锟叫该达拷锟诫并锟斤拷锟截★拷
锟斤拷锟斤拷锟狡硷拷锟斤拷锟阶帮拷锟斤拷锟斤拷锟叫╋拷锟斤拷锟斤拷锟斤拷锟斤拷锟斤拷约锟�CREATE LANGUAGE锟斤拷锟筋本锟斤拷锟斤拷一锟斤拷extension锟叫ｏ拷锟斤拷锟斤拷一锟斤拷锟津单碉拷CREATE EXTENSION锟斤拷锟斤拷锟斤拷锟斤拷园锟阶帮拷锟斤拷锟斤拷浴锟斤拷锟斤拷诒锟叫达拷锟秸癸拷锟斤拷锟较拷锟斤拷锟斤拷 36.15 锟斤拷锟斤拷
锟节筹拷锟皆憋拷写锟斤拷锟皆硷拷锟斤拷锟斤拷锟皆达拷锟斤拷锟斤拷时锟斤拷锟斤拷锟斤拷锟节憋拷准锟斤拷锟斤拷锟叫的癸拷锟斤拷锟斤拷锟斤拷锟角很好的参匡拷锟斤拷锟斤拷锟斤拷源锟斤拷锟斤拷锟叫碉拷src/pl锟斤拷目录锟斤拷CREATE LANGUAGE锟轿匡拷页也锟斤拷一些锟斤拷锟矫碉拷细锟节★拷