On Fri, Nov 03, 2006 at 11:39:47AM -0600, Gabriel Cook wrote: > So, is there any way to of thing with a BLOB? > > > WHERE substr(data, 1, 1) == x'bc'
This works: WHERE substr(data, 1, 1) == CAST(X'...' AS TEXT); but only as long as X'...' has no NULs. And probably only as lon as data contains no NULs too, at least before X'...'. The problem is that substr() returns TEXT, not BLOBs. Can you add an extension that adds a function that works like substr() but on BLOBs and returning BLOBs? Nico -- ----------------------------------------------------------------------------- To unsubscribe, send email to [EMAIL PROTECTED] -----------------------------------------------------------------------------
