An incorrect example in /docs/user/sql-select.htm

Started by Wessel van Norelover 25 years ago2 messagesdocs
Jump to latest
#1Wessel van Norel
wessel.van.norel@ddnh.nl

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

#2Bruce Momjian
bruce@momjian.us
In reply to: Wessel van Norel (#1)
Re: An incorrect example in /docs/user/sql-select.htm

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