--- In Firebird-Java@yahoogroups.com, "burghard_w_v_britzke"
<bubi@c...> wrote:

> two things/thinks about it;
> with "select max(colname) from table" you query the result of an

aggregate =

> function. so
> you get exact one! row and that you should expect!
> But, Stefan does firebird accept "select max(colname) AS rsname from

table"=

> (with AS
> keyword)?

That's a good point (that you should get one and exactly one
result).... but is this correct when there are zero rows to start
with? Shouldn't this be reflected by the agregate function returning
zero rows? :-)