nyarly

Imagine I've defined a grammar G. It's a ... predicate grammar (I think that's the right term) 
such that some of it's rules look like:

KeyValue -> KeyName ': ' ValueString { kv_pair: [key, value] }
KeyName -> [A-Za-z]+ { key: <matchstring> }
ValueString -> [^ ]+ { value: <matchstring> }

A fragment from a string in the language is like

judson: confused

rgreenjr

-- show running queries (pre 9.2)
SELECT procpid, age(clock_timestamp(), query_start), usename, current_query 
FROM pg_stat_activity 
WHERE current_query != '<IDLE>' AND current_query NOT ILIKE '%pg_stat_activity%' 
ORDER BY query_start desc;

-- show running queries (9.2)
SELECT pid, age(clock_timestamp(), query_start), usename, query 
FROM pg_stat_activity 
WHERE query != '<IDLE>' AND query NOT ILIKE '%pg_stat_activity%'