Thread: select MIN/MAX when no row selected

Hi All,

I think I had read this question with count(*) before.....

PgSql returns one row with a null field when we use select MIN or MAX on a
table, but the result should be "no rows selected".

I didn't try with C function, but I got the same result with psql.

So, I'm sending a Java example to Peter.

try {   rs=stmt.executeQuery("select min(field1) from tab where
field1>maxValueOfField1");   if (rs.next()) {       System.out.println("I found a row !!!!");
theResult=rs.getString(1);      if (theResult==null)           System.out.println("Min of field1 is NULL !!!!");   }
 
} catch (.............

maxValueofField1 = select max(field1) from tab;

Is it correct ?

I'm using PgSql 6.5.2, RHLinux/Intel 6.0

Thanks,

Ricardo Coelho.