No easy way to handle multi-line strings

[GoogleCodeExporter]

This will run OK:

CREATE FUNCTION my_function() RETURNS something
    AS 'BEGIN SELECT x INTO y FROM my_table; RETURN y; END;';

This will not:

CREATE FUNCTION my_function() RETURNS something AS '
BEGIN
    SELECT x INTO y FROM my_table;
    RETURN y;
END;';

I've tried a variety of multi-line string formattings, including blackslash 
'\', double-backslash '\\', changing the delimiter (eg. '$$' or '//') but 
nothing seems to work. What is recommended?

Using:
Apache Maven 3.0.3
com.dbdeploy:maven-dbdeploy-plugin:3.0M3
Windows 7 + CentOS 64bit
PostgreSQL 9.1rc1

Original issue reported on code.google.com by stewart....@gmail.com on 20 Mar 2012 at 10:21

[GoogleCodeExporter]

Ok, so I'm having a Homer Simpson day ...

I've solved this by use of the 'delimitertype' argument and judicious location 
of the ';' delimiter in each SQL script.

Original comment by stewart....@gmail.com on 20 Mar 2012 at 11:27