"Trevor Tingey" <[EMAIL PROTECTED]> writes:
> I ran the following queries and got unexpected results:
> UPDATE Account
> SET "Password" = 'password1'
> WHERE "AccountName" = 'Trevor'
> SELECT *
> FROM Account
> WHERE "AccountName" = 'Trevor'
> AND "Password" = 'password2'
> (I ran them individually)
> The Select query unexpectedly returned a result.
This is not a bug --- chkpass limits passwords to 8 significant
characters, so the above two values are in fact equal so far as
the datatype is concerned.
(The documentation probably ought to point that out...)
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
