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 rod@xxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
