The following bug has been logged on the website:
Bug reference: 8467
Logged by: Richard Neill
Email address: postgresql@richardneill.org
PostgreSQL version: 9.3.0
Operating system: Documentation bug
Description:
The documentation for pgcrypto:
http://www.postgresql.org/docs/current/static/pgcrypto.html
(and indeed all versions from 8.3-9.3)
contains the following:
--------------------
Example of authentication:
SELECT pswhash = crypt('entered password', pswhash) FROM ... ;
This returns true if the entered password is correct.
--------------------
I found this confusing, because it's using the same name, "pswhash" in 2
places, one of which is a boolean. It would be, imho, clearer to write the
example query as:
--------------------
SELECT is_authenticated = crypt('entered password', pswhash) FROM ... ;
--------------------
[Also, should the default example perhaps use gen_salt('bf'), as opposed to
gen_salt('md5') ?]
