Received: from primaire.intelcom.fr (primaire.intelcom.fr [194.250.33.1]) by hub.org (8.10.1/8.10.1) with ESMTP id e8F93rs31826 for ; Fri, 15 Sep 2000 05:03:53 -0400 (EDT) Received: from volvo.intelcom.fr ([192.168.160.20]) by primaire.intelcom.fr (8.8.8+Sun/8.8.8) with SMTP id LAA23382 for ; Fri, 15 Sep 2000 11:03:28 +0200 (MET DST) Received: from intelcom.fr by volvo.intelcom.fr (SMI-8.6/SMI-SVR4) id LAA09851; Fri, 15 Sep 2000 11:03:16 +0200 Message-ID: <39C1E5D4.6D0F1DFC@intelcom.fr> Date: Fri, 15 Sep 2000 11:03:16 +0200 From: Jerome Raupach X-Mailer: Mozilla 4.75 [en] (X11; U; SunOS 5.5 sun4d) X-Accept-Language: en MIME-Version: 1.0 To: pgsql-sql@postgresql.org Subject: Error with DISTINCT Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200009/110 testdb=#SELECT DISTINCT table_2.f1, table_1.f2, '2000-08-22' AS testdb-#date FROM table_1, table_2 WHERE table_1.f1 = table_2.f1; ERROR: Unable to identify an ordering operator '<' for type 'unknown' Use an explicit ordering operator or modify the query I must execute this query : testdb=#SELECT table_2.f1, table_1.f2, '2000-08-22' AS date FROM testdb-#table_1, table_2 WHERE table_1.f1 = table_2.f1 GROUP BY testdb-#table_2.f1, table_1.f2; Is it a bug ? Thanks in advance. Jerome.