Re: Regex help again (sorry, I am bad at these)

From: Melvin Davidson <melvin6925(at)gmail(dot)com>
To: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
Cc: Christopher Molnar <cmolnar(at)ourworldservices(dot)com>, PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Regex help again (sorry, I am bad at these)
Date: 2015-12-28 19:52:56
Message-ID: CANu8FiwiWVr-tmV23YKpf2YsNYB6kqzp6brdafgc-_yW9GWJqQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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(dot)g(dot)johnston(at)gmail(dot)com> wrote:

> On Mon, Dec 28, 2015 at 12:25 PM, Melvin Davidson <melvin6925(at)gmail(dot)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.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Molnar 2015-12-28 19:58:02 Re: Regex help again (sorry, I am bad at these)
Previous Message David G. Johnston 2015-12-28 19:42:23 Re: Regex help again (sorry, I am bad at these)