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