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> |