Error with DISTINCT - Mailing list pgsql-sql

From Jerome Raupach
Subject Error with DISTINCT
Date
Msg-id 39C1E5D4.6D0F1DFC@intelcom.fr
Whole thread Raw
Responses Re: Error with DISTINCT
List pgsql-sql
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
modifythe 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.


pgsql-sql by date:

Previous
From: Michael Teter
Date:
Subject: get table schema in psql?
Next
From: Patrik Kudo
Date:
Subject: Re: get table schema in psql?