From: | Jon Jensen <jon(at)endpoint(dot)com> |
---|---|
To: | Postgresql Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: massive quotes? |
Date: | 2003-09-10 18:36:39 |
Message-ID: | Pine.LNX.4.50.0309101833260.1303-100000@louche.swelter.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> >On Wed, Sep 10, 2003 at 07:04:13PM +0200, Andreas Pflug wrote:
> >
> >>>I assume we never came to a final conclusion on how to do CREATE
> >>>FUNCTION without double-quoting.
> >
> >>Many discussions, but no final conclusion in sight, it seems. That
> >>\beginliteral stuff is psql centric, where a sql syntax solution is needed.
> >
> >Oh, is it? Didn't people agree that other frontends (pgAdmin,
> >phpPgAdmin, etc) have solutions for the problem already?
I would really prefer a general SQL block quoting mechanism. Although I
can use Perl to escape all the quotes in a function block, it'd be really
nice to be able to do everything in SQL.
May I bring up here documents again? They have the advantage over the
COPY-like mechanism of being general, e.g.:
INSERT INTO sometable (field1, field2)
VALUES (1234, <<EOF
A really
long
text block's place
in the world
EOF
);
as well as being very nice in a function definition. What do others think
of that?
Jon
From | Date | Subject | |
---|---|---|---|
Next Message | Bruno Wolff III | 2003-09-10 18:42:18 | Re: Stats Collector Error 7.4beta1 and 7.4beta2 |
Previous Message | Peter Eisentraut | 2003-09-10 18:19:52 | Re: Notices for redundant operations |