| From: | pgsql-hackers(at)mail(dot)remote(dot)org |
|---|---|
| To: | pgsql-hackers(at)postgresql(dot)org |
| Subject: | Quoting in stored procedures |
| Date: | 1999-08-28 21:27:46 |
| Message-ID: | 199908282127.RAA16020@hub.org |
| Views: | Whole Thread | Raw Message | 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 | Michael Richards | 1999-08-29 00:40:29 | entries in pg_shadow |
| Previous Message | Jochen Topf | 1999-08-28 21:19:30 | Quoting in stored procedures |