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@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
> rod@iol.ie
>