I am writing a stored procedure where I have an input parameter called my_size that is an INTEGER. I want to be able to use it in a
LIMIT clause in a
SELECT statement. Apparently this is not supported, is there a way to work around this?
# I want something like: SELECT * FROM some_table LIMIT my_size; # Instead of hardcoding a permanent limit: SELECT * FROM some_table LIMIT 100;