Postgres Pro
Downloads
Home   >   mailing lists

Re: Regex help again (sorry, I am bad at these) - Mailing list pgsql-general

From David G. Johnston
Subject Re: Regex help again (sorry, I am bad at these)
Date
Msg-id CAKFQuway=4hU-P5+hziutH7s-p2ox9f=oBDw4JFwpVH330kRBQ@mail.gmail.com
Whole thread Raw
In response to Re: Regex help again (sorry, I am bad at these)  (Melvin Davidson <melvin6925@gmail.com>)
Responses Re: Regex help again (sorry, I am bad at these)  (Melvin Davidson <melvin6925@gmail.com>)
List pgsql-general
Tree view
On Mon, Dec 28, 2015 at 12:25 PM, Melvin Davidson <melvin6925@gmail.com> wrote:
Will this work?

UPDATE your_table
   SET your_column = REPLACE (your_column, 'HVACR1114_LAB_13A.pdf', '&file=HVACR1114_LAB_13A.pdf')
 WHERE <whatever_expression is needed>;

Your mileage may vary because you have not stated your VERSION of PostgreSQL or your O/S.


​What part of your solution is version or O/S dependent?

David J.
​
 

pgsql-general by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Regex help again (sorry, I am bad at these)
Next
From: Melvin Davidson
Date:
Subject: Re: Regex help again (sorry, I am bad at these)