Thread: An incorrect example in /docs/user/sql-select.htm
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
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