Skip site navigation (1) Skip section navigation (2)

Re: 7.0.3 max function

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: khtae(at)selim(dot)co(dot)kr, pgsql-bugs(at)postgresql(dot)org
Subject: Re: 7.0.3 max function
Date: 2001-03-28 16:00:04
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-bugs
pgsql-bugs(at)postgresql(dot)org writes:
> 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)

Hm.  It works for me, and doubtless for most other people.  Something
is badly wrong with your installation.  What platform are you on, and
how did you obtain or compile Postgres?  If you enabled locale support,
what locale are you running the postmaster in?

			regards, tom lane

In response to

pgsql-bugs by date

Next:From: pgsql-bugsDate: 2001-03-28 16:37:52
Subject: Datatype SERIAL incorrectly interpreted
Previous:From: Tom LaneDate: 2001-03-28 15:22:56
Subject: Re: pg_dump potential bug

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group