pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedquoting
3+ messages / 3 participants
[nested] [flat]
* quoting
@ 2004-06-30 05:12 Aaron W. West <tallpeak@hotmail.NO.SPAM>
2004-07-02 03:56 ` Re: quoting Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 3+ messages in thread
From: Aaron W. West @ 2004-06-30 05:12 UTC (permalink / raw)
To: pgsql-sql
I'm not a pgsql user, but reading chapter 37 of the user docs -
plpgsql-statements.html, I see that PL/pgsql requires quotes around FUNCTION
and PROCEDURE text, and I just want to comment that that seems like a rather
unfortunate decision. I like MS SQL's batch separation with GO better, but
lacking that, might there be an optional different quoting syntax, perhaps
like the HEREDOC syntax of bash or Perl, or like Perl's q() or qq() quoting
operators (or q{}, q[], etc)?
At least new users would be able to write their pl/pgsql commands in syntax
that doesn't require 2, 4, 8, or more single quote characters to represent
one.
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: quoting
2004-06-30 05:12 quoting Aaron W. West <tallpeak@hotmail.NO.SPAM>
@ 2004-07-02 03:56 ` Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 2004-07-02 03:56 UTC (permalink / raw)
To: Aaron W. West <tallpeak@hotmail.NO.SPAM>; +Cc: pgsql-sql
"Aaron W. West" <tallpeak@hotmail.NO.SPAM> writes:
> I see that PL/pgsql requires quotes around FUNCTION
> and PROCEDURE text, and I just want to comment that that seems like a rather
> unfortunate decision.
There's been something done about this for 7.5. See the pgsql-hackers
archives concerning "dollar quoting".
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: quoting
@ 2004-07-02 07:04 Michael Kleiser <mkl@webde-ag.de>
0 siblings, 0 replies; 3+ messages in thread
From: Michael Kleiser @ 2004-07-02 07:04 UTC (permalink / raw)
To: 'Aaron W. West' <tallpeak@hotmail.NO.SPAM>; pgsql-sql
I could not found an other quoting.
This quoting us annoying me also.
I would be nice to have an additional simpler quoting
in one of the next versions.
-------------------------------------
From: pgsql-sql-owner@postgresql.org
[mailto:pgsql-sql-owner@postgresql.org]
Sent: Mittwoch, 30. Juni 2004 07:12
To: pgsql-sql@postgresql.org
Topic: [SQL] quoting
I'm not a pgsql user, but reading chapter 37 of the user docs -
plpgsql-statements.html, I see that PL/pgsql requires quotes around FUNCTION
and PROCEDURE text, and I just want to comment that that seems like a rather
unfortunate decision. I like MS SQL's batch separation with GO better, but
lacking that, might there be an optional different quoting syntax, perhaps
like the HEREDOC syntax of bash or Perl, or like Perl's q() or qq() quoting
operators (or q{}, q[], etc)?
At least new users would be able to write their pl/pgsql commands in syntax
that doesn't require 2, 4, 8, or more single quote characters to represent
one.
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo@postgresql.org so that your
message can get through to the mailing list cleanly
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2004-07-02 07:04 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2004-06-30 05:12 quoting Aaron W. West <tallpeak@hotmail.NO.SPAM>
2004-07-02 03:56 ` Tom Lane <tgl@sss.pgh.pa.us>
2004-07-02 07:04 Re: quoting Michael Kleiser <mkl@webde-ag.de>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox