The following bug has been logged on the website: Bug reference: 8467 Logged by: Richard Neill Email address: postgre...@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') ?] -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
