Re: 7.0.3 max function

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