Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] regexp_matches where clause - PG 9.1 - Mailing list pgsql-general

From Arjen Nienhuis
Subject Re: [GENERAL] regexp_matches where clause - PG 9.1
Date
Msg-id CAG6W84+wEsqK0DBBeA_Diz06RiTOb5aTXxvVMnnFjAdbtWf78g@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] regexp_matches where clause - PG 9.1  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view


On Apr 7, 2017 4:08 AM, "David G. Johnston" <david.g.johnston@gmail.com> wrote:
On Thu, Apr 6, 2017 at 6:33 PM, Patrick B <patrickbakerbr@gmail.com> wrote:
When actually I just want the 'main''

​SELECT * FROM tbl WHERE path_name ~ '/main$' ?

David J.
​

Or just:

SELECT 'main';

pgsql-general by date:

Previous
From: Patrick B
Date:
Subject: Re: [GENERAL] regexp_matches where clause - PG 9.1
Next
From: Arjen Nienhuis
Date:
Subject: Re: [GENERAL] regexp_matches where clause - PG 9.1