Search Postgresql Archives

Re: regexp_matches where clause - PG 9.1

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 





On Apr 7, 2017 4:16 AM, "Patrick B" <patrickbakerbr@xxxxxxxxx> wrote:


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.

WHERE (path_name)::text ~ '^/filesuser/client/\d+/attachment/\d+/main$'




[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux