If you have, for example;
SELECT * FROM data WHERE line = min( (SELECT length FROM lines) ) AND number < 500;
(It's just an example, not a real code)
How does PostgreSQL react when the result from the MIN has a number > 500 ? Is he then going after the second MIN or what happens ?