update _tabel_ set path=replace(path, '/path/', '/new_path/'); On Thu, 2004-01-22 at 12:28, Patrascu Eugeniu wrote: > salut, > intr-un postgres am un tabel cu capuri de de felul: > > Column | Type | Modifiers > --------+-------------------+----------- > id | numeric | > path | character varying | > > > iar in tabel am inregistrari de genul: > > > id | path > ----+------------------------ > 1 | some/path/some_file > 2 | some/path/another_file > (2 rows) > > > problema e ca trebuie sa modific path-ul. astfel incat de > "some/path/some_file" sa am "some/new_path/some_file". stiu ca pgsql > stie de regular expressions si as vrea sa stiu care este echivalentul in > postgresql pentru un statement UPDATE pentru a realiza ce se face in sed > ~$ echo "/some/path/some_file" | sed -e "s/path/new_path/" > /some/new_path/some_file > > tia, -- Alex Crivat
WWW: http://axu.rdsnet.ro GPG: http://axu.rdsnet.ro/pgp.txt e-Mail: [EMAIL PROTECTED] ____________________________________ Open source -> Millions of opened minds can't be wrong -- Attached file included as plaintext by Ecartis -- -- File: signature.asc -- Desc: This is a digitally signed message part -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.2 (GNU/Linux) iQEVAwUAQA+33MfDzXQDxJGXAQKNIQf+IVrnmbUIVcsqYqL7bKlIb7pa7fgZ7XbG uckOHM8Rc4MqgtldvCGNA/DBH72dqpxVDHYJgNUQZV5Ab6BB2Z28JphZl2Kdlsjq Dwl10EkB1udRbPfnbd7Vds8NxBSAaqXKRy5hwinSaNdxoB7UjildBA/gzKX1HEoK cv2ep3Ieos9NS5LI5aBKTCBjSg/Kl6fgkZTuqjitWgJjs8Sy4J3HI8FcUv6U5pSk M63nFz/gXboSda0V6DObC1vvQTWMJKIK76FxtPMkaYI1v5VuE02D0OsTlHqIixLM ebvBCTZ2CJGteFhR3kQlUliD8XPRHtZ0NlpEo858iJ3rsgeycZP5ew== =zLTM -----END PGP SIGNATURE----- --- Detalii despre listele noastre de mail: http://www.lug.ro/
