dollar quoting for plpgsql

Tom Lane wrote:

>
>
>I think plpgsql's lexer also needs to be taught about dollar-quoting.
>
>
>
>

The attached patch appears to do the trick:

floobl=# create or replace function testme() returns text language
plpgsql as $$
floobl$# begin return $foo$a'\b$bar$foo$; end;
floobl$# $$;
CREATE FUNCTION
floobl=# select testme();
testme
----------
a'\b$bar
(1 row)

floobl=#

cheers

andrew