Home > mailing lists

update - Mailing list pgsql-novice

From	cristi
Subject	update
Date	February 26, 2002 14:44:05
Msg-id	004d01c1be90$de2ddc00$7201a8c0@dmhi.ct.ro Whole thread Raw
Responses	Re: update (Jason Earl <jason.earl@simplot.com>)
List	pgsql-novice

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!

From: Anton de Wet
Date: 26 February 2002, 14:37:29
Subject: Re: Dates in postgres

From: Phil Mitchell
Date: 26 February 2002, 16:59:17
Subject: Help formulating multi-table SELECT statement