Quick Links

Re: Sort problem

From:	Jean-Luc Lachance <jllachan(at)nsd(dot)ca>
To:
Cc:	pgsql-sql(at)postgresql(dot)org
Subject:	Re: Sort problem
Date:	2002-02-25 21:53:29
Message-ID:	3C7AB259.A66B2282@nsd.ca
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general pgsql-sql

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

In response to

Re: [SQL] Sort problem at 2002-02-25 19:46:37 from Bruce Momjian

Responses

Re: Sort problem at 2002-02-25 23:09:21 from Tom Lane

Browse pgsql-general by date

	From	Date	Subject
Next Message	Tom Lane	2002-02-25 22:09:55	Re: Wierdness using SUM to add results of custom C function.
Previous Message	Thomas T. Thai	2002-02-25 21:51:48	Re: help with getting index scan

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Dan Langille	2002-02-25 22:08:56	record iteration within SQL
Previous Message	Bruce Momjian	2002-02-25 20:03:42	Re: [SQL] Sort problem