Re: 7.0.3 max function

On Wed, Mar 28, 2001 at 08:30:39AM -0500, pgsql-bugs(at)postgresql(dot)org wrote:
> Tae, KwangHo (khtae(at)selim(dot)co(dot)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(at)zf(dot)jcu(dot)cz>
http://home.zf.jcu.cz/~zakkr/

C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz