Hello , ============================================================================ POSTGRESQL BUG REPORT TEMPLATE ============================================================================ Your name : Vladimir Kamaev Your email address : [EMAIL PROTECTED] System Configuration --------------------- Architecture (example: Intel Pentium) : Intel Pentium II Operating System (example: Linux 2.0.26 ELF) : Linux 2.2.10 PostgreSQL version (example: PostgreSQL-6.5.3): PostgreSQL-6.5.3 Compiler used (example: gcc 2.8.0) : gcc-2.7.2.3 Please enter a FULL description of your problem: ------------------------------------------------ Bad result? ===================================== test=> \i 00 CREATE TABLE test ( num int4, price float ); CREATE SELECT num, max( price ) FROM test GROUP BY num; num|max ---+--- | (1 row) DROP TABLE test; DROP EOF test=> ===================================== Please describe a way to repeat the problem. Please try to provide a concise reproducible example, if at all possible: ---------------------------------------------------------------------- If you know how this problem might be fixed, list the solution below: --------------------------------------------------------------------- Best regards, Kamaev mailto:[EMAIL PROTECTED]