Hi,

Ludovic Brenta wrote:
Sorry to interrupt but in standard SQL there is

    WHERE id LIKE 'deadbe%'

and I happen to use it occasionally on the command line.  I'm worried
that that won't be possible anymore after the unhexification.

Agreed. Unfortunately the '%' doesn't work that well for binary values, so yes, you would loose the ability to query directly via LIKE.

The following supposedly still works, provided you use a monotone enhanced sqlite, which provides an unhex() function:

   WHERE unhex(id) LIKE 'deadbe%'

Regards

Markus



_______________________________________________
Monotone-devel mailing list
Monotone-devel@nongnu.org
http://lists.nongnu.org/mailman/listinfo/monotone-devel

Reply via email to