On Wed, Mar 28, 2001 at 08:30:39AM -0500, [EMAIL PROTECTED] wrote:
> Tae, KwangHo ([EMAIL PROTECTED]) 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 <[EMAIL PROTECTED]>
http://home.zf.jcu.cz/~zakkr/
C, PostgreSQL, PHP, WWW, http://docs.linux.cz, http://mape.jcu.cz
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
