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 [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly