X-Original-To: pgsql-www-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 311E5D1CA5C; Thu, 20 Nov 2003 17:44:27 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 75204-09; Thu, 20 Nov 2003 13:43:56 -0400 (AST) Received: from smtp-send.myrealbox.com (smtp-send.myrealbox.com [192.108.102.143]) by svr1.postgresql.org (Postfix) with ESMTP id F1695D1CAC2; Thu, 20 Nov 2003 13:43:54 -0400 (AST) Received: from myrealbox.com grzm@smtp-send.myrealbox.com [218.46.12.215] by smtp-send.myrealbox.com with NetMail SMTP Agent $Revision: 3.44 $ on Novell NetWare; Thu, 20 Nov 2003 10:43:31 -0700 Date: Fri, 21 Nov 2003 02:43:23 +0900 Subject: Re: [DOCS] 7.4 official docs : Fonts? Content-Type: text/plain; charset=US-ASCII; format=flowed Mime-Version: 1.0 (Apple Message framework v552) Cc: Bruce Momjian , pgsql-www@postgresql.org, pgsql-docs@postgresql.org To: Roberto Mello From: Michael Glaesemann In-Reply-To: <20031120173107.GA3050@cc.usu.edu> Message-Id: <099BD9A5-1B81-11D8-BDB7-0005029FC1A7@myrealbox.com> Content-Transfer-Encoding: 7bit X-Mailer: Apple Mail (2.552) X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200311/357 X-Sequence-Number: 3004 On Friday, November 21, 2003, at 02:31 AM, Roberto Mello wrote: > On Thu, Nov 20, 2003 at 12:16:58PM -0500, Bruce Momjian wrote: >> Michael Glaesemann wrote: >>> When I was experimenting with different color schemes, I thought >>> about >>> perhaps matching the syntax coloring of my editor, BBEdit. However, >>> I'm >>> sure not all editors use the same color scheme (the ANSI SQL language >>> module for BBEdit displays only blue (keywords), pink (strings), and >>> black (everything else). The blue would conflict with the current >>> link >>> color, and I'd rather not use pink unless everyone else thinks it's a >>> good idea.) I'm interested in hearing what editors others use for >>> coding, and what syntax coloring schemes they use for SQL. > > I use vim, it has good SQL coloring syntax. The one problem that I'd > like > to fix in it is that the body of PL/pgSQL functions are shown as a big > string. I know what you mean. Same thing in BBEdit. Really, that's what they are, but it'd be nice if there were some way of distinguishing the parts of the strings. One of the issues is that (at least for BBEdit) the SQL syntax coloring is based on ANSI SQL, not PostgreSQL. I'd like to hack my own language module for this, but haven't got around to doing it. On Friday, November 21, 2003, at 02:16 AM, Bruce Momjian wrote: > Yes, colorizing editors really help me understand the code. I use > Crisp, which is a commercial editor. Visiting the CRiSP site, I see they have a Mac version for demo. I'll give it a whirl, and see what their colors are like. Michael