Quote:
Originally posted by Raven_Writer
D'oh...all well, sorry about that. I thought I mixed it up. Can you do "CASE > 4" or just "CASE pw_12 > 4"?
|
The first one is legal (CASE >4). The second is not legal syntax. Here's a good way to thing of the operators: imagine taking the SELECT variable/expression (from SELECT expr) and putting it immediately in front of the thing after CASE. ie
SELECT p1_y
CASE <127
...
can be thought of as an if with predicate p1_y<127.