Postgres Pro
Downloads
Home   >   mailing lists

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

From Melvin Davidson
Subject Re: Regex help again (sorry, I am bad at these)
Date
Msg-id CANu8FiwiWVr-tmV23YKpf2YsNYB6kqzp6brdafgc-_yW9GWJqQ@mail.gmail.com
Whole thread Raw
In response to Re: Regex help again (sorry, I am bad at these)  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-general
Tree view
Although, in this particular case, it is not version or O/S specific, it is generally a good policy (and manners) to state them whenever contacting this mail list.
In that way, future users that refer back to problems have it documented as to which are and are not version specific.

On Mon, Dec 28, 2015 at 2:42 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
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.
​
 



--
Melvin Davidson
I reserve the right to fantasize.  Whether or not you
wish to share my fantasy is entirely up to you.

pgsql-general by date:

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