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:
Will this work?Your mileage may vary because you have not stated your VERSION of PostgreSQL or your O/S.
UPDATE your_table
SET your_column = REPLACE (your_column, 'HVACR1114_LAB_13A.pdf', '&file=HVACR1114_LAB_13A.pdf')
WHERE <whatever_expression is needed>;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.
I reserve the right to fantasize. Whether or not you
wish to share my fantasy is entirely up to you.