Re: hi,i write a function in postgresql source code, how to register this function?

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 <rod(at)iol(dot)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
> rod(at)iol(dot)ie
>