Postgres Pro
Downloads
Home   >   mailing lists

Re: Sort problem - Mailing list pgsql-sql

From Jean-Luc Lachance
Subject Re: Sort problem
Date
Msg-id 3C7AB259.A66B2282@nsd.ca
Whole thread Raw
In response to Re: Sort problem  (Bruce Momjian <pgman@candle.pha.pa.us>)
Responses Re: Sort problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-sql
Tree view 
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

pgsql-sql by date:

Previous
From: Oliver Elphick
Date:
Subject: Re: [GENERAL] Sort problem
Next
From: "Dan Langille"
Date:
Subject: record iteration within SQL