Search Postgresql Archives

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

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxx> wrote:
On Mon, Dec 28, 2015 at 12:25 PM, Melvin Davidson <melvin6925@xxxxxxxxx> 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.


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux