Received: from beamish.nsd.ca (unknown [205.150.156.194]) by postgresql.org (Postfix) with ESMTP id 151FA475D23 for ; Mon, 25 Feb 2002 16:43:21 -0500 (EST) Received: (from smap@localhost) by beamish.nsd.ca (8.9.3/8.9.3) id QAA06889 for ; Mon, 25 Feb 2002 16:43:22 -0500 X-Authentication-Warning: beamish.nsd.ca: smap set sender to using -f Received: from reddog.nsd.ca(192.168.101.30) by beamish.nsd.ca via smap (V2.1/2.1+anti-relay+anti-spam) id xma006887; Mon, 25 Feb 02 16:43:01 -0500 Received: from nsd.ca (jllachan-linux.nsd.ca [192.168.101.148]) by reddog.nsd.ca (8.8.7/8.8.7) with ESMTP id QAA32696 for ; Mon, 25 Feb 2002 16:44:53 -0500 Message-ID: <3C7AB259.A66B2282@nsd.ca> Date: Mon, 25 Feb 2002 16:53:29 -0500 From: Jean-Luc Lachance X-Mailer: Mozilla 4.77 [en] (X11; U; Linux 2.4.9-12 i686) X-Accept-Language: en MIME-Version: 1.0 Cc: pgsql-sql@postgresql.org Subject: Re: Sort problem References: <200202251946.g1PJkbn04775@candle.pha.pa.us> Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Archive-Number: 200202/370 X-Sequence-Number: 6792 Hi all, Can someone (Tom maybe) please tell me why one can not use an alias from the select list in the where clause or the order by clause. It would make things much easier where using computed fields. JLL