Rodrigo Carvalhaes <[EMAIL PROTECTED]> writes:
> My problem is the "select max(id) FROM test" the result is 20 but the 
> right is 1020. Is this a BUG or I am crazy ??

You seem to be confused about the difference between numbers and
character strings.  max() on a char(n) column returns the
lexicographically largest item.

                        regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

Reply via email to