Received: from tidal.ipinc.com (tidal.ipinc.com [199.245.188.85]) by hub.org (8.10.1/8.10.1) with ESMTP id e8FLdms79590 for ; Fri, 15 Sep 2000 17:39:48 -0400 (EDT) Received: from ipinc.com (jliang.ipinc.com [199.245.188.130]) by tidal.ipinc.com (8.9.3/8.9.3) with ESMTP id OAA49476; Fri, 15 Sep 2000 14:39:37 -0700 (PDT) (envelope-from jliang@ipinc.com) Message-ID: <39C29666.2689C66@ipinc.com> Date: Fri, 15 Sep 2000 14:36:38 -0700 From: Jie Liang Organization: ipinc.com X-Mailer: Mozilla 4.7 [en] (X11; U; FreeBSD 3.4-RELEASE i386) X-Accept-Language: en MIME-Version: 1.0 To: Jerome Raupach CC: pgsql-sql@postgresql.org Subject: Re: Error with DISTINCT References: <39C1E5D4.6D0F1DFC@intelcom.fr> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200009/118 Hi, try this: testdb=#SELECT DISTINCT table_2.f1, table_1.f2, date('2000-08-22') AS testdb-#date FROM table_1, table_2 WHERE table_1.f1 = table_2.f1; Jerome Raupach wrote: > 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. -- Jie LIANG Internet Products Inc. 10350 Science Center Drive Suite 100, San Diego, CA 92121 Office:(858)320-4873 jliang@ipinc.com www.ipinc.com