X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 3030DD1B198 for ; Wed, 30 Jun 2004 02:14:42 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 35167-08 for ; Wed, 30 Jun 2004 05:14:35 +0000 (GMT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by svr1.postgresql.org (Postfix) with ESMTP id 5EAB5D1B18A for ; Wed, 30 Jun 2004 02:14:33 -0300 (ADT) Received: from news.hub.org (news.hub.org [200.46.204.72]) by news.hub.org (8.12.9/8.12.9) with ESMTP id i5U5EXQC045235 for ; Wed, 30 Jun 2004 05:14:33 GMT (envelope-from news@news.hub.org) Received: (from news@localhost) by news.hub.org (8.12.9/8.12.9/Submit) id i5U5CBOR045071 for pgsql-sql@postgresql.org; Wed, 30 Jun 2004 05:12:11 GMT From: "Aaron W. West" X-Newsgroups: comp.databases.postgresql.sql Subject: quoting Date: Tue, 29 Jun 2004 22:12:09 -0700 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1409 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1409 Message-ID: Lines: 13 X-Complaints-To: abuse@speakeasy.net X-DMCA-Complaints-To: abuse@speakeasy.net X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your complaint properly X-Postfilter: 1.1 To: pgsql-sql@postgresql.org X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=1.9 tagged_above=0.0 required=5.0 tests=NO_DNS_FOR_FROM, PRIORITY_NO_NAME X-Spam-Level: * X-Archive-Number: 200407/10 X-Sequence-Number: 18262 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.