Received: from thor.tht.net (thor.tht.net [209.47.145.4]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eB8KBIZ05833 for ; Fri, 8 Dec 2000 15:11:18 -0500 (EST) (envelope-from pgman@candle.pha.pa.us) Received: from candle.pha.pa.us (pgman@candle.navpoint.com [162.33.245.46]) by thor.tht.net (8.9.3/8.9.3) with ESMTP id QAA15077 for ; Fri, 8 Dec 2000 16:11:22 GMT (envelope-from pgman@candle.pha.pa.us) Received: (from pgman@localhost) by candle.pha.pa.us (8.9.0/8.9.0) id PAA22511; Fri, 8 Dec 2000 15:11:05 -0500 (EST) From: Bruce Momjian Message-Id: <200012082011.PAA22511@candle.pha.pa.us> Subject: Re: An incorrect example in /docs/user/sql-select.htm In-Reply-To: <3A1D4230.2AEAC6A0@ddnh.nl> "from Wessel van Norel at Nov 23, 2000 05:13:36 pm" To: Wessel van Norel Date: Fri, 8 Dec 2000 15:11:05 -0500 (EST) CC: pgsql-docs@postgresql.org X-Mailer: ELM [version 2.4ME+ PL77 (25)] MIME-Version: 1.0 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII X-Archive-Number: 200012/14 X-Sequence-Number: 61 Thanks. Fixed. > Hello, > > I found an incorrect example in the user documentation about the SELECT > statement. > In the part: > Compatibility > Extensions > > The example: > SELECT distributors.* WHERE name = 'Westwood'; > did | name > -----+---------- > 108 | Westward > > So if I SELECT 'Westwood' I get 'Westward' ?? > I guess it should be: > SELECT distributors.* WHERE name = 'Westward'; > > And if you search on the web, you find this problem more times: > http://www.postgresql.org/docs/aw_pgsql_book/node1024.html > http://www.postgresql.org/mhonarc/pgsql-docs/1999-07/msg00000.html > http://www.postgresql.org/mhonarc/pgsql-hackers/1999-07/msg00014.html > > Regards, > > Wessel van Norel > -- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026