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

[sunpeng <bluevaley@xxxxxxxxx>]

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@xxxxxx>

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