Auf Thema antworten

Kannst Du nicht direkt beim INSERT das erledigen?

[code]

test=# select length('BAP_DER_VS_0402_100n_+-10%_16V_123_''####''_457');

 length

--------

     45

(1 row)

test=*# create table mindhunter(t varchar(40));

CREATE TABLE

test=*# insert into mindhunter select substring('BAP_DER_VS_0402_100n_+-10%_16V_123_''####''_457',1,40);

INSERT 0 1

test=*# select * from mindhunter ;

                    t                    

------------------------------------------

 BAP_DER_VS_0402_100n_+-10%_16V_123_'####

(1 row)

test=*# select t, length(t) from mindhunter ;

                    t                     | length

------------------------------------------+--------

 BAP_DER_VS_0402_100n_+-10%_16V_123_'#### |     40

(1 row)

test=*#

[/code]