Re: regexp_matches where clause - PG 9.1

From: Arjen Nienhuis <a(dot)g(dot)nienhuis(at)gmail(dot)com>
To: Patrick B <patrickbakerbr(at)gmail(dot)com>
Cc: pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: regexp_matches where clause - PG 9.1
Date: 2017-04-06 05:35:41
Message-ID: CAG6W84L8zq-VSQCHN91xJ1LD8u9tJni6044jyWfcFoOdfO_Z0g@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Apr 6, 2017 05:57, "Patrick B" <patrickbakerbr(at)gmail(dot)com> wrote:

Hi guys,

i've got this column:

path_name character varying(255)
>

I store full S3 bucket path for the attachments of my application on it;
example:

/{s3bucket}/filesuser/client/27801123/attachment/4510/main
>
/{s3bucket}/filesuser/client/27801123/attachment/4510/file
>

I wanna do a select, where path_name has only 'main' and not anything else.

WHERE path_nane LIKE '%/main'

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Patrick B 2017-04-06 06:10:57 Re: regexp_matches where clause - PG 9.1
Previous Message Adrian Klaver 2017-04-06 04:14:44 Re: A change in the Debian install