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é
|