Postgres Pro
Downloads
Home   >   mailing lists

Thread: quoting

quoting

From
"Aaron W. West"
Date:
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.

Re: quoting

From
Tom Lane
Date:
"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

Re: quoting

From
Michael Kleiser
Date:
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.orgso that your     message can get through to the mailing list cleanly