User Tools

Site Tools


sql_analysis

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
sql_analysis [2018/04/20 09:47] danielsql_analysis [2019/01/24 17:55] (current) – [Presence and count of specific mail headers] daniel
Line 52: Line 52:
 <code sql> <code sql>
 select FIELD||':'||arr[1], count(*) select FIELD||':'||arr[1], count(*)
- from (select FIELD, regexp_matches(lines, '(?:^|\n)' || FIELD || ':\s*([^\n]*)\n', 'g') as arr+ from (select FIELD, regexp_matches(lines, '(?:^|\n)' || FIELD || ':\s*([^\n]*)', 'gi') as arr
        from header,         from header, 
          (VALUES ('X-Priority'), ('Importance'), ('Precedence'), ('Priority'),          (VALUES ('X-Priority'), ('Importance'), ('Precedence'), ('Priority'),
sql_analysis.1524217621.txt.gz · Last modified: 2018/04/20 09:47 by daniel