[SQL] search/replace in update

[Gary Stainburn]

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 


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]

[SQL] Re: Timestamp without time zone

[Vivek Khera]

> "PS" == Pasi Salminen <[EMAIL PROTECTED]> writes:

PS> I am trying to create table with a field which type is timestamp
PS> and I don't want it to be timestamp with time zone.

This question has been asked at least 4 times since I've been
following this list, including once by me.

Appaarently, nobody seems to have an answer.  The docs imply that type
timstamp is without timezone, since there is a type "timestamp with
timezone".  If you do a "\d tablename" in psql, it shows "timestamp
with timezone" on all your fields you declare as timestamp.  This
leads me to believe that they are silently "upgraded" in their type.

I have a subroutine in my apps that strips the timezone before passing
it along to the users.

-- 
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Vivek Khera, Ph.D.Khera Communications, Inc.
Internet: [EMAIL PROTECTED]   Rockville, MD   +1-240-453-8497
AIM: vivekkhera Y!: vivek_khera   http://www.khera.org/~vivek/

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly