> Wouldn't that return files from directories '/tmp1', '/tmp2', for example? I believe so.
> I thought the goal was to return files and subdirectories recursively inside > '/tmp'. I'm not sure what the purpose of the query was. The query query will return inodes where the file path starts with "/tmp" > select filename from inode where filename >= ‘/tmp/’ and filename < ‘/tmp0’ > and sentinel = ‘x’; > > Would this work? Sounds ok. Cheers ----------------- Aaron Morton Freelance Developer @aaronmorton http://www.thelastpickle.com On 18/09/2012, at 11:41 PM, André Cruz <andre.c...@co.sapo.pt> wrote: > 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é > >
