From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
---|---|
To: | Sibtay Abbas <sibtay_abbas(at)yahoo(dot)com> |
Cc: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: adding procedural languages |
Date: | 2004-12-07 15:14:01 |
Message-ID: | 41B5C8B9.1080406@dunslane.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Dunstan | 2004-12-07 15:18:19 | Re: How can I recovery old Data from files and folders |
Previous Message | Tom Lane | 2004-12-07 15:13:13 | Re: apparent problem on linux/s390 |