copy a long from one row to another

Hello

I'm looking for a method to duplicate a row is should be something like that :

insert into psources
(pid, doc)
select 999, pdoc
  from psources
  where pid = 111;

where doc is a long.
Long are a little bit unsual to manage, so what can i do ?

Thanks

Nico Received on Thu Nov 25 1999 - 06:01:10 CST