Hi Affan,
Please read this SQL/PSM thread over and then address how EDB did it (and of course how you would recommend generalizing it for PG 8.2).
Perhaps our SQL/PSM could be designed from the ground up with "debugability" :-) in mind.
--Luss
From: Alvaro Herrera [mailto:alvherre@surnet.cl]
Sent: Sun 6/26/2005 6:06 PM
To: Andrew Dunstan
Cc: Denis Lussier; pgsql-hackers@postgresql.org
Subject: Re: [HACKERS] Implementing SQL/PSM for PG 8.2
On Sun, Jun 26, 2005 at 06:06 -05, Alvaro Herrera wrote:
> I've seen some example code on the EnterpriseDB website using their SPL
> language, and it doesn't seem to be handled like "just another PL". The
> function body does not look at all like quoted strings, as in our
> regular PLs. I don't know how they did it, but I don't think they added
> support for the whole language to the main parser.