copying BLObs

From: Nigel Campbell <nigelc_at_cognos.com>
Date: Sat, 5 Jun 1993 17:15:30 GMT
Message-ID: <1993Jun5.171530.1618_at_cognos.com>


In some engines it is valid to make a 'quick' copy of a BLOb column by just assigning the BLOb id held in the column of the source row into the corresponding column in the target row. Sort of like making another link to a UNIX file. Can someone confirm which other engines support/disallow this?

INGRES, SYBASE, ORACLE and INFORMIX.

thanks.

-- 
Nigel Campbell          Voice: (613) 738-1338 ext 3016    P.O. Box 9707
Cognos Incorporated       FAX: (613) 738-0002             3755 Riverside Dr.
UNIX and RDBMS            MCI: nigel campbell || 307-4729 Ottawa, Ontario
UUnet: nigelc_at_cognos.COM                                  CANADA  K1G 3Z4
Received on Sat Jun 05 1993 - 19:15:30 CEST

Original text of this message