update part of a column record

From: Marc Fromm <Marc(dot)Fromm(at)wwu(dot)edu>
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: update part of a column record
Date: 2009-09-08 16:46:14
Message-ID: B0D7C0A3F35FE144A70312D086CBCA9B03A8B89406@ExchMailbox2.univ.dir.wwu.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

I have a column that contains user email addresses. I need to update all email address in the column that end with @cc.edu to @ss.edu and retain the information (the user name) that exists before the @ symbol. Is there an update query that can edit part of a column record?

Marc

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Aras Angelo 2009-09-08 16:54:34 Re: update part of a column record
Previous Message raghu ram 2009-09-07 21:32:45 Re: POSTGRES.. NEED HELP