How to apply max function for each row in KDB?

Question

I want to ensure all values in column x are no smaller than 0.5, so I do:

update x:max (x 0.5) from myTable

But this gives an error (in Studio For KDB+):

An error occurred during execution of the query.
The server sent the response:
type
Studio Hint: Possibly this error refers to wrong type, e.g `a+1

What's wrong?

Answer 1

You can try using |

q)update x|0.5 from myTable

Answer 2

It should work. It worked for me. This is the query I used for testing:

update x:max(x;0.5) from myTable

-- Check semicolon in max function