Only updating part of a column

From: Dave Smith <dave(at)candata(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Only updating part of a column
Date: 2000-07-24 19:07:55
Message-ID: 397C940B.54130A32@candata.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I would like to know if I can update part of a column. ie

update myfile set substr(direct_key,1,10)='1234567890' where
substr(direct_key,1,10)='0987654321';

This does not work. Is this possible? Or am I looking at this the wrong
way?

--
Dave Smith
Candata Systems Ltd.
(416) 493-9020
dave(at)candata(dot)com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Nathan Barnett 2000-07-24 19:20:31 Statistical Analysis
Previous Message George Henson 2000-07-24 19:03:55 problem with check constraint using a select command.