Re: BLOBS

On April 26, 2004 11:54 am, David Wall wrote:
> n Oracle, we had to actually insert an empty_blob()
> and then follow that up with an SQL UPDATE to set the blob data.  I'm not
> sure why they need two SQL calls to insert a blob, but that's how it
> appears to "work" in Oracle.

OT for a postgresql list, but if you default the column to EMPTY_BLOB() you
don't have to do that:

  ...
  myBlob   BLOB DEFAULT EMPTY_BLOB(),
  ...

Oh, and have you had the cool one yet where you update a BLOB (or CLOB) with
less data then already in there and you end up with you new data plus the
'end' of the original BLOB? You need to reset w/ EMPTY_BLOB() prior to
updating a BLOB as well.

Oh, the suckiness of Oracle. Don't get me started.

JdV!!

--
--------------------------------------------------------------
Jan de Visser                     jdevisser@digitalfairway.com

                Baruk Khazad! Khazad ai-menu!
--------------------------------------------------------------