Martijn van Oosterhout wrote:
On Wed, Aug 13, 2008 at 10:47:17AM -0600, Jeff Ross wrote:
I'm a little confused about how to use a column alias in the where
clause of a query. I'm sure the answer is something simple, but I
haven't found anything searching through Google or from reading the docs.
You can't. Conceptually, the result of the SELECT is not visible until
*after* the WHERE clause has executed, so having the where clause
depend on the select won't work.
Ah, now I get it!
What you can do is put the CASE stuff in a subquery:
SELECT * FROM
(SELECT fc_facility_id, fc_name, CASE ...etc... )
WHERE fc_director_name ilike ('%Cobb%');
This way the inner select is done first, calculating the fields you
want, then the outer select can use the result.
Perfect! Thank you!
Jeff
Have a nice day,
------------------------------------------------------------------------
!DSPAM:48a31748228425368819438!
