On Sep 18, 2012, at 3:06 AM, aaron morton <aaron@thelastpickle.com> wrote:

select filename from inode where filename > ‘/tmp’ and filename < ‘/tmq’ and sentinel = ‘x’;

Wouldn't that return files from directories '/tmp1', '/tmp2', for example? I thought the goal was to return files and subdirectories recursively inside '/tmp'.

If we store the slash with the parent_path, so '/tmp/', maybe we can search for:

select filename from inode where filename >= ‘/tmp/’ and filename < ‘/tmp0’ and sentinel = ‘x’;

Would this work?

Thanks,
André