The syntax needed for defining functions is quite annoying because of the
needed quoting. Example:

CREATE FUNCTION bla (int4) RETURNS char AS '
        BEGIN
                RETURN ''Two quotes needed''
        END;
' LANGUAGE 'plpgsql';

How about allowing something like in shell here-documents:

CREATE FUNCTION bla (int4) RETURNS char LANGUAGE 'plpgsql' UNTIL '__EOF__';
        BEGIN
                RETURN 'Only one quote needed'
        END;
__EOF__

Or similar. The __EOF__ is of course totally arbitrary and every string can
be used, so this will work with any language used.

jochen


Sat, 28 Aug 1999 23:19:30 +0200
Jochen Topf <sqrt@eldorado.inka.de>
Quoting in stored procedures