Subject | Re: [firebird-support] Using <> and/or IS DISTINCT FROM with BLOB columns |
---|---|
Author | Thomas Steinmaurer |
Post date | 2010-04-27T09:13:21Z |
> I vaguely remember starting with a particular Firebird version, that theAny ideas?
> <> operator can be used on BLOB data to compare old and new BLOB data in
> an AFTER UPDATE trigger.
>
> Is the <> operator supposed to work on BLOB columns? If yes, for both,
> SUB_TYPE 1 *and* 0? If so, starting with what version?
>
> How about IS DISTINCT FROM on BLOB columns?
Thanks.
--
Best Regards,
Thomas Steinmaurer
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and
NexusDB V2
Upscene Productions
http://www.upscene.com
My blog:
http://blog.upscene.com/thomas/