support_functions
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | Last revision Both sides next revision | ||
|
support_functions [2012/08/25 09:55] daniel |
support_functions [2017/05/26 13:46] daniel [get_header_line()] |
||
|---|---|---|---|
| Line 80: | Line 80: | ||
| CREATE FUNCTION get_header_line(int, text) RETURNS SETOF text | CREATE FUNCTION get_header_line(int, text) RETURNS SETOF text | ||
| AS $$ | AS $$ | ||
| - | SELECT (regexp_matches(lines, E'^'||$2||': (.*?)$', 'gni'))[1] | + | SELECT (regexp_matches(lines, '^'||$2||': (.*?)$', 'gni'))[1] |
| FROM header WHERE mail_id=$1; | FROM header WHERE mail_id=$1; | ||
| $$ LANGUAGE sql; | $$ LANGUAGE sql; | ||
| </file> | </file> | ||
support_functions.txt ยท Last modified: 2018/04/20 13:17 by daniel
Page Tools
Except where otherwise noted, content on this wiki is licensed under the following license: CC Attribution-Noncommercial-Share Alike 4.0 International
