On Wed, Mar 28, 2001 at 08:30:39AM -0500, pgsql-bugs@postgresql.org wrote:
> Tae, KwangHo (khtae@selim.co.kr) reports a bug with a severity of 3
> The lower the number the more severe it is.
>
> Short Description
> 7.0.3 max function
>
> Long Description
> create table aaa ( aa varchar(3) );
> insert into aaa values ('001');
> insert into aaa values ('002');
> insert into aaa values ('003');
>
> select max(aa) from aaa;
> max
> -----
> 002
> (1 row)
>
7.1:
test=# create table aaa ( aa varchar(3) );
CREATE
test=# insert into aaa values ('001');
INSERT 87956 1
test=# insert into aaa values ('002');
INSERT 87957 1
test=# insert into aaa values ('003');
INSERT 87958 1
test=#
test=# select max(aa) from aaa;
max
-----
003
(1 row)
test=#
Karel
--
Karel Zak <zakkr@zf.jcu.cz>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz