All entries for Wednesday 08 March 2006
March 08, 2006
So I wanted to run a query which would return a number of rows if their ids were in a set:
select url from page where id in (....)
This works fine.
Unfortunately it breaks horribly if the set is empty. Why? There is no mathematical ambiguity about an empty set. Why would oracle simply not return 0 rows?