Re: regexp_matches where clause - PG 9.1

[Patrick B <patrickbakerbr@xxxxxxxxx>]

2017-04-07 14:08 GMT+12:00 David G. Johnston <david.g.johnston@xxxxxxxxx>:

On Thu, Apr 6, 2017 at 6:33 PM, Patrick B <patrickbakerbr@xxxxxxxxx> 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.