Postgres Pro
Downloads
Home   >   mailing lists

Only updating part of a column - Mailing list pgsql-general

From Dave Smith
Subject Only updating part of a column
Date
Msg-id 397C940B.54130A32@candata.com
Whole thread Raw
List pgsql-general
Tree view 
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@candata.com

pgsql-general by date:

Previous
From: "George Henson"
Date:
Subject: problem with check constraint using a select command.
Next
From: "Nathan Barnett"
Date:
Subject: Statistical Analysis