> On Jan 8, 2020, at 3:13 AM, Simon Slavin <slav...@bigfraud.org> wrote:
> 
> I believe Jens' point is valid, as long as you don't have to search/scan 
> headers.

You can even do that — to search for a specific header’s value, just create an 
index on json_extract(headers, ‘$Header-Name’), then in a query use that same 
expression in an equality or relational comparison.

(You’ll need to normalize the case of header names during the JSON conversion 
while inserting, since JSON keys are case-sensitive but RFC822 header names 
aren’t.)

—Jens
_______________________________________________
sqlite-users mailing list
sqlite-users@mailinglists.sqlite.org
http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to