Received: from hotmail.com (law-f139.hotmail.com [209.185.131.202]) by hub.org (8.9.3/8.9.3) with SMTP id KAA37193 for ; Tue, 30 May 2000 10:13:34 -0400 (EDT) (envelope-from oomoomi@hotmail.com) Received: (qmail 6042 invoked by uid 0); 30 May 2000 14:13:00 -0000 Message-ID: <20000530141300.6041.qmail@hotmail.com> Received: from 195.200.226.110 by www.hotmail.com with HTTP; Tue, 30 May 2000 07:13:00 PDT X-Originating-IP: [195.200.226.110] From: "omid omoomi" To: jeff@pgsql.com, pfiche@prologue-software.fr Cc: pgsql-sql@postgresql.org Subject: RE: 7.0 weirdness Date: Tue, 30 May 2000 07:13:00 PDT Mime-Version: 1.0 Content-Type: text/plain; format=flowed X-Archive-Number: 200005/197 If so then why do you need to use "select distinct " ?! BTW, I just tested on my 6.5.2, This query : "Select distinct f1 from table1 order by f2 " works the same as this one: "select distinct f1,f2 from table1" >From: Jeff MacDonald >Reply-To: Jeff MacDonald >To: Patrick FICHE >CC: Jeff MacDonald , Pgsql-Sql >Subject: RE: [SQL] 7.0 weirdness >Date: Tue, 30 May 2000 10:46:30 -0300 (ADT) > >gid is unique.. > >jeff > >On Tue, 30 May 2000, Patrick FICHE wrote: > > > It seems to me that it was lack of control in 6.5 version... > > For one "gid", you may have several "created" values, so Postgres is not > > able to decide which value must be taken and ordered > > > > Simple example > > gid created > > 1 1 > > 1 3 > > 2 2 > > > > In which order is Postgres supposed to give the data??? > > > > > > Patrick Fiche > > -----Message d'origine----- > > De : pgsql-sql-owner@hub.org [mailto:pgsql-sql-owner@hub.org]De la part > > de Jeff MacDonald > > Envoyé : mardi 30 mai 2000 14:28 > > À : pgsql-sql@postgresql.org; pgsql-hackers@postgresql.org > > Objet : [SQL] 7.0 weirdness > > > > > > hi folks, > > > > this query works fine in 6.5 but screwie in 7.0 > > > > 7.0 > > > > gm=> SELECT DISTINCT gid FROM members > > gm-> WHERE active = 't' > > gm-> AND (gender = 0 > > gm-> AND (wantrstypemale LIKE '%Short Term%' > > gm-> OR wantrstypemale like '%Marriage%' > > gm-> OR wantrstypemale like '%Long Term%' > > gm-> OR wantrstypemale like '%Penpal%' > > gm-> OR wantrstypemale like '%Activity Partner%') > > gm-> ) order by created desc; > > ERROR: For SELECT DISTINCT, ORDER BY expressions must appear in target >list > > gm=> > > > > > > any idea's ? > > > > jeff > > > > > > > > > ________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com