Received: from mail.postgresql.org (webmail.postgresql.org [216.126.85.28]) by mail.postgresql.org (8.11.1/8.11.1) with SMTP id eAUGlqt40763 for ; Thu, 30 Nov 2000 11:47:52 -0500 (EST) (envelope-from pgsql-docs-owner@postgresql.org) Received: from ns.mediacenter.nl (ns.mediacenter.nl [193.67.150.35]) by mail.postgresql.org (8.11.1/8.11.1) with ESMTP id eANGK9A67333 for ; Thu, 23 Nov 2000 11:20:09 -0500 (EST) (envelope-from wessel.van.norel@ddnh.nl) Received: from enschede3.ddnh (root@[195.108.13.33]) by ns.mediacenter.nl (8.9.3/8.9.3) with ESMTP id RAA24414 for ; Thu, 23 Nov 2000 17:20:17 +0100 Received: from ddnh.nl (pc12.ddnh [195.108.13.52]) by enschede3.ddnh (8.9.3/8.8.8) with ESMTP id RAA29651 for ; Thu, 23 Nov 2000 17:11:04 +0100 Message-ID: <3A1D4230.2AEAC6A0@ddnh.nl> Date: Thu, 23 Nov 2000 17:13:36 +0100 From: Wessel van Norel X-Mailer: Mozilla 4.5 [en] (WinNT; I) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-docs@postgresql.org Subject: An incorrect example in /docs/user/sql-select.htm Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200011/43 X-Sequence-Number: 46 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