From mboxrd@z Thu Jan 1 00:00:00 1970 Path: main.gmane.org!not-for-mail From: Michael Mauger Newsgroups: gmane.emacs.devel Subject: Re: Patch for sql.el Date: Fri, 7 May 2004 08:27:03 -0700 (PDT) Sender: emacs-devel-bounces+emacs-devel=quimby.gnus.org@gnu.org Message-ID: <20040507152703.46444.qmail@web60306.mail.yahoo.com> References: NNTP-Posting-Host: deer.gmane.org Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Trace: sea.gmane.org 1083944066 11456 80.91.224.253 (7 May 2004 15:34:26 GMT) X-Complaints-To: usenet@sea.gmane.org NNTP-Posting-Date: Fri, 7 May 2004 15:34:26 +0000 (UTC) Cc: emacs-devel@gnu.org Original-X-From: emacs-devel-bounces+emacs-devel=quimby.gnus.org@gnu.org Fri May 07 17:34:16 2004 Return-path: Original-Received: from quimby.gnus.org ([80.91.224.244]) by deer.gmane.org with esmtp (Exim 3.35 #1 (Debian)) id 1BM7Me-0008Mp-00 for ; Fri, 07 May 2004 17:34:16 +0200 Original-Received: from monty-python.gnu.org ([199.232.76.173]) by quimby.gnus.org with esmtp (Exim 3.35 #1 (Debian)) id 1BM7MS-0002BU-00 for ; Fri, 07 May 2004 17:34:15 +0200 Original-Received: from localhost ([127.0.0.1] helo=monty-python.gnu.org) by monty-python.gnu.org with esmtp (Exim 4.30) id 1BM7GJ-00022O-46 for emacs-devel@quimby.gnus.org; Fri, 07 May 2004 11:27:43 -0400 Original-Received: from list by monty-python.gnu.org with tmda-scanned (Exim 4.30) id 1BM7GD-000224-TG for emacs-devel@gnu.org; Fri, 07 May 2004 11:27:37 -0400 Original-Received: from mail by monty-python.gnu.org with spam-scanned (Exim 4.30) id 1BM7Fh-0001sV-6s for emacs-devel@gnu.org; Fri, 07 May 2004 11:27:36 -0400 Original-Received: from [216.109.118.117] (helo=web60306.mail.yahoo.com) by monty-python.gnu.org with smtp (Exim 4.30) id 1BM7Fg-0001sE-Gg for emacs-devel@gnu.org; Fri, 07 May 2004 11:27:04 -0400 Original-Received: from [204.167.53.85] by web60306.mail.yahoo.com via HTTP; Fri, 07 May 2004 08:27:03 PDT Original-To: Stefan Monnier In-Reply-To: X-BeenThere: emacs-devel@gnu.org X-Mailman-Version: 2.1.4 Precedence: list List-Id: "Emacs development discussions." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-devel-bounces+emacs-devel=quimby.gnus.org@gnu.org Xref: main.gmane.org gmane.emacs.devel:22906 X-Report-Spam: http://spam.gmane.org/gmane.emacs.devel:22906 --- Stefan Monnier wrote: > > (defun font-lock-add-syntax (syntax-alist) > > (defun font-lock-remove-syntax (syntax-alist) > [..] > > Or are we pushing the feature freeze...? > > Not only that, but I feel it's just adding ad-hoc cruft above ad-hoc > cruft. > Understood. I figured it was worth exploring. > Is there any particular reason why you don't merge all those submodes > and simply handle a language that's a superset of all? > Basically accept @ # $ as symbol components, and accept all the > keywords of all the known servers... > That should simplify your code. > The problem with SQL is that there is no real standard. The core is standard, but the functions and procedural extensions vary significantly from one product to another. One of the reasons I originally started using sql-mode was that I was using two database products at the same time (oracle and ms). The product specific features helped keep me sane. For example, Oracle calls its sub-string function `substr' whereas MS (and ANSI) call it `substring'. I go back 20+ years with Oracle so my instinct is the abbreviated form. When I used the abbreviated form in MS scripts I had immediate feedback that I had used the wrong form. I have one more patch coming for sql.el that removes, at compile time, keywords in product specific lists that are also in the ANSI list. This slows the compile time, but seems to speed up the fontification. It also allows me to keep the entire product specific keyword lists in the source without manually filtering out the keywords duplicated in ANSI. I will keep the font-lock reset code as it is for now. Thanks for your assistance and recommendations. Michael ===== -- Michael Mauger http://www.geocities.com/mmaug/ As my friends know all too well, 'Mike' is a four-letter word.