I do not try,
may be it exists different languages to make this in postgresql :
I make this in pl/pgsql, I do not have time to make this in C,
CREATE OR REPLACE FUNCTION "_replaceblock" (text, text, text) RETURNS
text AS'
DECLARE
text_begin ALIAS FOR $1 ;
key_name ALIAS FOR $2 ;
key_val
I have a field in one of my tables that has a path to a file listed. I
need to move those files and now have to update all those paths. Is
there a simply search and replace type option in sql? or do I need to
do an update using the entire new path name?
If so, I think the easier solution will b
On Thu, Jan 09, 2003 at 19:15:51 -0500,
"Randy D. McCracken" <[EMAIL PROTECTED]> wrote:
>
> Hi Rajesh,
>
> I don't know why but the example you gave me did not work. Here is what
> happened when I tried:
>
> ==
>
> pubs_test=# UPDATE publications SET url = replace( 'www.srs.fs.fed.us
On Thu, 9 Jan 2003, Ross J. Reedstrom wrote:
> On Thu, Jan 09, 2003 at 11:00:32AM +0530, Rajesh Kumar Mallah. wrote:
> >
> > any anyone explain whats wrong with the replace based solution to this problem
> > which i posted earlier?
> >
> > did i misunderstood anything?
>
> Probably just overkill -
On Thu, Jan 09, 2003 at 11:00:32AM +0530, Rajesh Kumar Mallah. wrote:
>
> any anyone explain whats wrong with the replace based solution to this problem
> which i posted earlier?
>
> did i misunderstood anything?
Probably just overkill - I'm sure it would work, but, based on how the
question was
any anyone explain whats wrong with the replace based solution to this problem
which i posted earlier?
did i misunderstood anything?
regds
mallah.
On Thursday 09 January 2003 01:48 am, Randy D. McCracken wrote:
> Just to close off another thread and to give a tad more information...
>
> I was
Just to close off another thread and to give a tad more information...
I was not clear enough in my initial question to the list because not all
of the URLs I am trying to change begin with http://www.srs.fs.fed.us/ so
what I was really looking for was the syntax for replacing
"www.srs.fs.fed.us"
On Wed, Jan 08, 2003 at 09:02:47AM -0500, Randy D. McCracken wrote:
> I apologize for having to resort to sending what is most likely a simple
> tech support question regarding PostgreSQL to this list but I have not
> been able to find the answer in the documentation.
Hey, this is Open Source: tha
REPLACE is the right function for you avaliable as an addon.
install it in postgresql installation using the source at:
http://www.brasileiro.net:8080/postgres/cookbook/view-one-recipe.adp?recipe_id=23
if you face problem please lemme know
once this function is installed you could update like:
On Wed, Jan 08, 2003 at 09:02:47 -0500,
"Randy D. McCracken" <[EMAIL PROTECTED]> wrote:
>
> UPDATE publications SET url = 'www.srs.fs.usda.gov' WHERE url =
> 'www.srs.fs.fed.us';
For simple cases you can do this with available string functions.
For more complicated cases, you can write a simple
I apologize for having to resort to sending what is most likely a simple
tech support question regarding PostgreSQL to this list but I have not
been able to find the answer in the documentation.
I am responsible for managing a database containing over 6,000 records of
US Forest Service Research pu
Hello Bruno,
try the following:
UPDATE journal
SET description = 'Add '||description
WHERE description LIKE '%PSF%;
Is this what you wanted?
Best regards, Jens Hartwig
Bruno Boettcher schrieb:
>
> hello,
>
> again fiddling around with SQL...
> wanted to loop over the Base search for S
hello,
again fiddling around with SQL...
wanted to loop over the Base search for Strings beginning with a
sequence and replace that sequence with another one.
tryed the following:
update journal set description='Add '||(select id description from
journal subq where subq.description like '%PS
13 matches
Mail list logo
