Sibtay Abbas wrote:
>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
>
>
>
>
Is this part of an academic project or something? Frankly, it looks to
me like you need to acquire a lot of basic knowledge about how
postgresql works internally before you even start thinking about what
you are trying to do.
Serverside PLs can only be used in user-defined functions, and the
language used is specified in the function definition, as in
create function foo() returns text language mypl as $$ <code in mypl> $$;
cheers
andrew