Re: regexp_matches where clause - PG 9.1

[Arjen Nienhuis <a.g.nienhuis@xxxxxxxxx>]

On Apr 7, 2017 4:08 AM, "David G. Johnston" <david.g.johnston@xxxxxxxxx> wrote:

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.

​

Or just:

SELECT 'main';