Re: update

----- Original Message -----

From: cristi

To: pgsql-novice@postgresql.org

Sent: Tuesday, February 26, 2002 12:13 PM

Subject: [NOVICE] update

I have a table (my_table) with this structure:

codlm varchar(7)

 

The records are:

45122AD
45122AD
45123AC
440331B
430332C
440222X

I want to change the first 2 letters from 45 to 22 something like this:

 

22122AD
22122AD
22123AC
440331B
430332C
440222X

I tried:

update my_table set codlm='22'||substring(codlm,2) where codlm like '45'

 

but the result is:

 225
 225
 225
 440331B
 430332C
 440222X

Where is the mistake?

 

Thanks!