List:General Discussion« Previous MessageNext Message »
From:Yves Goergen Date:December 4 2003 5:41pm
Subject:Re: WHERE with CASE colums?
View as plain text  
On Thursday, December 04, 2003 6:22 PM CET, Martijn Tonies wrote:
> Cause the WHERE clause only works on columns. If you want to
> do a match on the result of the CASE, you have to do your case
> thingy again:
> 
> WHERE ( case ...yourstuff... end ) = 'something'

Wouldn't HAVING help here?

-- 
Yves Goergen
nospam.list@stripped
Please don't CC me (causes double mails)
Thread
WHERE with CASE colums?Scott Turnbull4 Dec
  • Re: WHERE with CASE colums?Martijn Tonies4 Dec
  • Re: WHERE with CASE colums?Yves Goergen4 Dec