Received: from maia.hub.org (maia-3.hub.org [200.46.204.243]) by mail.postgresql.org (Postfix) with ESMTP id CD20F632B09 for ; Wed, 9 Jun 2010 03:59:35 -0300 (ADT) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia, port 10024) with ESMTP id 98887-09 for ; Wed, 9 Jun 2010 06:59:27 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mail-iw0-f174.google.com (mail-iw0-f174.google.com [209.85.214.174]) by mail.postgresql.org (Postfix) with ESMTP id C0FE563278B for ; Wed, 9 Jun 2010 03:59:27 -0300 (ADT) Received: by iwn37 with SMTP id 37so5549723iwn.19 for ; Tue, 08 Jun 2010 23:59:26 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=googlemail.com; s=gamma; h=domainkey-signature:mime-version:received:sender:received :in-reply-to:references:date:x-google-sender-auth:message-id:subject :from:to:cc:content-type; bh=tRURvWMbh3lMsb4oJ/EdZDgUYpTFE1AqPxVdSeBiixg=; b=PDcMDDMB3yIZxD1h34dQzvRwDx4optwCFjY7+seOgnu/MqN2Sr+z61Vud7vLJpgpw6 2x0EGL+cfayuhg1I/TtLZgBeJ/OeD1TChgXt/nOwRZNmkGAM3rVRwesXk3WcgabzBQc3 orUvFhUf7hCk/PvEOJmlEvXoXyj8S7iWbPqwI= DomainKey-Signature: a=rsa-sha1; c=nofws; d=googlemail.com; s=gamma; h=mime-version:sender:in-reply-to:references:date :x-google-sender-auth:message-id:subject:from:to:cc:content-type; b=Bt8mRwoH2+vnjdLiUhYQg4Z8UIUz10Wg/zo4FRDsrlLYJ2Rhul4OxKfSPjIAMi06tk EKMd1Q/2ehXLe7YKnqgWx8qxVnIperz9AC70T++wlwP6B9eevyY4yFtSrhXb6xWty+bu lTAdNg2tmQTI+JAsrGWFhoFxNtcqXBtJsvCT0= MIME-Version: 1.0 Received: by 10.231.189.103 with SMTP id dd39mr7442788ibb.199.1276066766208; Tue, 08 Jun 2010 23:59:26 -0700 (PDT) Received: by 10.231.68.138 with HTTP; Tue, 8 Jun 2010 23:59:25 -0700 (PDT) In-Reply-To: <1C4CA63C-DD35-4554-81CE-4E2A94548CA6@numericable.fr> References: <29FD1BB6-9AD8-485C-B5D2-23D66C15DC97@numericable.fr> <1C4CA63C-DD35-4554-81CE-4E2A94548CA6@numericable.fr> Date: Wed, 9 Jun 2010 08:59:25 +0200 X-Google-Sender-Auth: I5FOi2AsRLwX-90xymcUQWbRF_E Message-ID: Subject: Re: Cognitive dissonance From: Brian Modra To: John Gage Cc: PostgreSQL - General Content-Type: text/plain; charset=ISO-8859-1 X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-0.001 tagged_above=-5 required=5 tests=BAYES_20=-0.001 X-Spam-Level: X-Archive-Number: 201006/408 X-Sequence-Number: 163945 On 09/06/2010, John Gage wrote: > 1) On a list that howls with complaints when posts are in html, it is > surprising that there is resistance to the idea of documentation in > plain text. > > 2) Posters are correctly referred to the documentation as frequently > as possible. In fact, very frequently. The frequency might decrease > if the documentation were in plain text. It is easier to search a > single plain text file than any other source, except perhaps the > database itself. > > 3) Postgres is getting pushed off the map at the low end by MySQL, now > owned by Oracle. If Postgres ceased to exist, Ellison would be > thrilled. I chose A2 Hosting (with whom I am very happy) for my > website because they support Postgres. I'm writing cgi scripts in > perl. I had to install the postgres driver for dbi. It was not pre- > installed. There are about four buttons for MySQL on the cPanel and > two farther over on the right for Postgres. > > An anecdote. I discovered the tsvector functionality a while back. I > have used it to create indices for my text files and several other > tasks. I recently was re-looking at my files and saw > "tsvector::text". I had forgotten that the double colon is one way to > cast a type. Double colon is not in the html index of the > documentation. I found it by searching my plain text version of the > pdf file. In my opinion, the html documentation is useful for reading > it like a novel or referencing it in these lists. > > > On Jun 8, 2010, at 9:56 PM, Josh Kupershmidt wrote: > >> Not that I see a whole lot of utility in this endeavor Personally I like to use html docs, and it would be good if the documentation were downloadable from the postgresql website in other formats, for convenience... But, what I use is this, which works pretty well: (e.g. to get the 8.1 dosc) mkdir postgresql cd postgresql wget -r -nH -l 10 -k -np http://www.postgresql.org/docs/8.1/interactive/index.html ... then after it all downloads: open the file docs/8.1/interactive/index.html in your web browser. e.g. links docs/8.1/interactive/index.html HTML is "text", so you can search using grep e.g. grep -r "ALTER TABLE .* ADD COLUMN" docs/8.1 > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general > -- Brian Modra Land line: +27 23 5411 462 Mobile: +27 79 69 77 082 5 Jan Louw Str, Prince Albert, 6930 Postal: P.O. Box 2, Prince Albert 6930 South Africa http://www.zwartberg.com/ Fax: +27865510467