How to remove rows from a table if their value is less than 10000?

Question

PostgreSQL

Tried such request: the request is fulfilled, and lines are not deleted.
DELETE FROM "pos" WHERE num = '<10000'

Answer 1

Maybe still ? UPD. If you have postgres, not mysql (by the way - what do you have? What motivates the simultaneous presence of these two tags?) - then you will probably need to do type conversion, something like this: . DELETE FROM pos WHERE num < 10000
num::integer < 10000