I'm trying to update a character field by foll. query:
update temp_kat set id_look = substr(ident,1,6) || '-' || substr(ident,7,7)
where from_kat='P';
Both id_look and ident are varchars.. So what's wrong with || operator? There
is an error parsing the querry near || ...
Who is stupid? Me, or postgresql 6.4.2 :) ? It look like legal expression for
me...
--
Michal Samek, Tony distribuce s.r.o.
webmaster@tony.cz (++420659/321350)
ICQ: 38607210