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?
Try the kdb vector conditional its similar to case-when in SQL:
You can try using |
It should work. It worked for me. This is the query I used for testing:
-- Check semicolon in max function