Manitou-Mail Wiki

User Tools

Site Tools

Trace:
support_functions

Differences

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

Link to this comparison view

Both sides previous revisionPrevious revision
Last revisionBoth sides next revision
support_functions [2012/08/25 07:55] – danielsupport_functions [2017/05/26 11:46] – [get_header_line()] daniel
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 11:17 by daniel