Re: Implementing SQL/PSM for PG 8.2

Alvaro Herrera wrote:

>On Sun, Jun 26, 2005 at 04:44:13PM -0400, Andrew Dunstan wrote:
>
>  
>
>>Is the intention here to make PSM a first class language (i.e. handled 
>>by the main dbengine scanner/parser) of just another PL? If the latter 
>>it seems far less worth doing. Doing this as a first class language, 
>>however, would be great, just great.
>>    
>>
>
>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.
>
>  
>

It could be done by putting the SPL parser in front of the SQL parser. 
Maybe Luss will tell us how it was done ;-)

cheers

andrew