| 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 Turnbull | 4 Dec |
| • Re: WHERE with CASE colums? | Martijn Tonies | 4 Dec |
| • Re: WHERE with CASE colums? | Yves Goergen | 4 Dec |