Hi !
I am quite confused of the results on a SELECT max...
My environment: Conectiva Linux 10, PostgreSQL 7.4.6 (compiled from the sources)
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 ??
Crazy. And posting to the wrong list - try the general/sql lists for this sort of thing.
teste=# CREATE TABLE test ( id char(15), name char(80) ); CREATE
You've defined "id" as char - so it's sorting alphabetically, not numerically, so 1111 < 2
Just defined "id" as a numeric type.
-- Richard Huxton Archonet Ltd
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster