On Apr 7, 2017 4:16 AM, "Patrick B" <patrickbake...@gmail.com> wrote:
2017-04-07 14:08 GMT+12:00 David G. Johnston <david.g.johns...@gmail.com>:
> On Thu, Apr 6, 2017 at 6:33 PM, Patrick B <patrickbake...@gmail.com>
> wrote:
>
>> When actually I just want the 'main''
>>
>
> SELECT * FROM tbl WHERE path_name ~ '/main$' ?
>
> David J.
>
>
David,
That won't work.
When performing the select, I got:
/{s3bucket}/filesuser/client/27801123/attachment/4510/file/1113/small/main
when actually i want:
/{s3bucket}/filesuser/client/27801123/attachment/4510/main
Patrick.
WHERE (path_name)::text ~ '^/filesuser/client/\d+/attachment/\d+/main$'
