search/replace in update

From: Gary Stainburn <gary(dot)stainburn(at)ringways(dot)co(dot)uk>
To: pgsql-sql(at)postgresql(dot)org
Subject: search/replace in update
Date: 2001-06-14 08:40:34
Message-ID: 01061409403400.06009@gary.ringways.co.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi all,

here in England OFTEL, the governing body for all things telephone
recent hand another phone number dialing code change (one of many).

This means that e.g. all mobile numbers that used to start 0589 now
start 07889.

Is there a way in SQL to update the phone number in-place?
--
Gary Stainburn

This email does not contain private or confidential material as it
may be snooped on by interested government parties for unknown
and undisclosed purposes - Regulation of Investigatory Powers Act, 2000

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Mark 2001-06-14 11:32:20 Moving between databases
Previous Message Pasi Salminen 2001-06-14 08:12:12 Timestamp without time zone