Обсуждение: update problem
hello in using postgres 8.3 on windows and i have aproblem to update a table, this is the facts, I have a tables where i want to update the name based on a lenght of a field for instance i want to update all the rows where the the substring(cuenta from 17 for 40) is equal around all the table may you have an idea how i could made it
thanks a lot
Get news, entertainment and everything you care about at Live.com. Check it out!
thanks a lot
Get news, entertainment and everything you care about at Live.com. Check it out!
In response to Paul Alarcon : > hello in using postgres 8.3 on windows and i have aproblem to update a table, > this is the facts, I have a tables where i want to update the name based on a > lenght of a field for instance i want to update all the rows where the the > substring(cuenta from 17 for 40) is equal around all the table may you have an > idea how i could made it > thanks a lot I'm not sure if i understand you, but how about test=*# select * from foobar; id | name ----+----------- 1 | 123 2 | 123abc123 3 | 234abc234 4 | 345abc345 5 | 123456789 (5 rows) -- change all the trings contains substring 'abc' from 4-6 position to -- 'hit' test=*# update foobar set name='hit' where substr(name, 4, 3)='abc'; UPDATE 3 test=*# select * from foobar; id | name ----+----------- 1 | 123 5 | 123456789 2 | hit 3 | hit 4 | hit (5 rows) HTH, Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net