It's just in postgresql 8.4 source code,e.g in /backend/executor/functions.c, not in sql,not in pl/pgsql
2010/6/16 Raymond O'Donnell <r...@iol.ie> > On 16/06/2010 17:42, sunpeng wrote: > > hi,i write a function in postgresql source code, how to register this > > function? > > it is not an aggregate function. > > i don't use 34.3"User-Defined Functions" described in > > http://www.postgresql.org/docs/8.4/interactive/xfunc.html, i just write > > it in postgresql sourcecode, how to register this function to let final > > user use? Should i only add one tuple in pg_process table? how to add ? > > What do you mean by "PostgreSQL source code"? - SQL? pl/pgsql? > > Generally, you just execute the following SQL command: > > create or replace function my_function(.....) returns [return type] > as > $$ > [function code here] > $$ > language [whatever - usually sql or plpgsql] ; > > > ....or am I missing something in your question? > > Ray. > > > -- > Raymond O'Donnell :: Galway :: Ireland > r...@iol.ie >
