Received: from www.chac.qld.edu.au (linux.chac.qld.edu.au [203.37.221.131] (may be forged)) by hub.org (8.9.3/8.9.3) with ESMTP id TAA90294 for ; Wed, 24 May 2000 19:04:27 -0400 (EDT) (envelope-from jhunt@chac.qld.edu.au) Received: from chac.qld.edu.au (chac.inet [203.37.221.129]) by www.chac.qld.edu.au (8.9.3/8.9.3) with ESMTP id IAA23078; Thu, 25 May 2000 08:59:22 +1000 (EST) (envelope-from jhunt@chac.qld.edu.au) Message-ID: <392C6046.E03F6DCF@chac.qld.edu.au> Date: Thu, 25 May 2000 09:05:43 +1000 From: Julie Hunt Reply-To: jhunt@chac.qld.edu.au Organization: Cannon Hill Anglican College X-Mailer: Mozilla 4.61 (Macintosh; I; PPC) X-Accept-Language: en MIME-Version: 1.0 To: Joseph Shraibman CC: "pgsql-sql@postgresql.org" Subject: Re: possible bug with group by? References: <392C5819.2FD488A8@selectacast.net> Content-Type: text/plain; charset=us-ascii; x-mac-type="54455854"; x-mac-creator="4D4F5353" Content-Transfer-Encoding: 7bit X-Archive-Number: 200005/128 Joseph Shraibman wrote: > > > playpen=> select a, b, case when c is null then 'not set' else 'set' end > as z from tablea group by a, b, z; > ERROR: Unable to identify an operator '<' for types 'unknown' and > 'unknown' > You will have to retype this query using an explicit cast > playpen=> Hi, should your group by be a, b, c not a, b, z? Regards Julie