From: | Jochen Topf <sqrt(at)eldorado(dot)inka(dot)de> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Quoting in stored procedures |
Date: | 1999-08-28 21:19:30 |
Message-ID: | 19990828231930.A7802@eldorado.inka.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
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
From | Date | Subject | |
---|---|---|---|
Next Message | pgsql-hackers | 1999-08-28 21:27:46 | Quoting in stored procedures |
Previous Message | Spirou | 1999-08-28 20:26:13 | [Fwd: bug ? get_groname: group 0 not found] |