support_functions
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
support_functions [2012/08/25 07:53] – [tag_id(text): returns the ID of a tag from its full hierarchical name] daniel | support_functions [2017/05/26 11:46] – [get_header_line()] daniel | ||
---|---|---|---|
Line 1: | Line 1: | ||
- | ====== tag_path(int): extract the tag name with its hierarchy | + | ====== tag_path(int) ====== |
+ | **Extract the tag name with its hierarchy.** \\ | ||
This recursive function takes the ID of a tag and returns its full name, including its hierarchy. | This recursive function takes the ID of a tag and returns its full name, including its hierarchy. | ||
Line 27: | Line 28: | ||
will retrieve all tags sorted and formatted as in the " | will retrieve all tags sorted and formatted as in the " | ||
- | ====== tag_depth(int): returns | + | |
+ | ====== tag_depth(int) | ||
+ | **Returns | ||
This recursive function takes the ID of a tag and returns its depth inside its hierarchy, starting by 1 for top-level tags. | This recursive function takes the ID of a tag and returns its depth inside its hierarchy, starting by 1 for top-level tags. | ||
Line 49: | Line 52: | ||
</ | </ | ||
- | ====== tag_id(text): returns | + | ====== tag_id(text) |
+ | **Returns | ||
This is the inverse function of tag_path(int). | This is the inverse function of tag_path(int). | ||
If the name is not found, it returns null. | If the name is not found, it returns null. | ||
Line 69: | Line 73: | ||
</ | </ | ||
- | ====== get_header_line(): extracts entries from a mail header | + | ====== get_header_line() ====== |
+ | **Extract entries from a mail header.** \\ | ||
This function takes a mail_id and the name of a header field and returns all corresponding header entries for this message. | This function takes a mail_id and the name of a header field and returns all corresponding header entries for this message. | ||
Line 75: | Line 80: | ||
CREATE FUNCTION get_header_line(int, | CREATE FUNCTION get_header_line(int, | ||
AS $$ | AS $$ | ||
- | | + | |
FROM header WHERE mail_id=$1; | FROM header WHERE mail_id=$1; | ||
$$ LANGUAGE sql; | $$ LANGUAGE sql; | ||
</ | </ |
support_functions.txt · Last modified: 2018/04/20 11:17 by daniel