On Sep 18, 2012, at 3:06 AM, aaron morton <aa...@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é
