hi everyone

ok i ve tried to add my own procedural language using
the call handler interface.

I am doining nothing in the handler function except
tyring to print a mess through errmsg function
(plz correct me if i am wrong here, since i cant see
the message which i am printing)

Now my question is that how can i explicitly specify
that i want my pl language to be used.

I think i have added my language successfully by
following the procedure mentioned in the
documentation.

So now how do i inform the database engine to use my
language for a specific query

thank you

you can use your procedural language in stored procedures of pgsql. you have to login (with psql client) to the server and issue a command like this:

create function <name> returns <type> as '
... your function here ...
' language <language>

note that the language has to be 'installed' in the database (with the createlang program).

greetz,
.-=~ iluvatar ~=-.