Received: from mailproxy.de.uu.net (mailproxy.de.uu.net [192.76.144.34])
	by postgresql.org (Postfix) with ESMTP id E0F13475894
	for <pgsql-sql@postgresql.org>; Wed, 10 Jul 2002 08:02:55 -0400 (EDT)
Received: from software.b.uunet.de (pec-68-67.tnt4.m2.uunet.de
 [149.225.68.67])
	by mailproxy.de.uu.net (5.5.5/5.5.5) with ESMTP id OAA04674
	for <pgsql-sql@postgresql.org>;
	Wed, 10 Jul 2002 14:02:58 +0200 (MET DST)
Message-ID: <3D2C2140.7060003@software.b.uunet.de>
Date: Wed, 10 Jul 2002 13:57:52 +0200
From: Andreas Schlegel <schlegel@software.b.uunet.de>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
	rv:1.0.0) Gecko/20020530
X-Accept-Language: en-us, en
MIME-Version: 1.0
To: pgsql <pgsql-sql@postgresql.org>
Subject: Error with DISTINCT and AS keywords
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
X-Archive-Number: 200207/133
X-Sequence-Number: 8512

Hi,

I need some help to let this sql statement run with Postgres 7.2.1

Doesn't work:
select DISTINCT tnr, titel, 'TEST' AS testcol from tTitel;
ERROR:  Unable to identify an ordering operator '<' for type 'unknown'
         Use an explicit ordering operator or modify the query

If I remove the DISTINCT keyword it works:
select tnr, titel, 'TEST' AS testcol from tTitel;



Greetings,
Andreas