search for: regexp_replac

Displaying 1 result from an estimated 1 matches for "regexp_replac".

Did you mean: regexp_replace
2009 Jan 19
0
Reject message if user is over quota. 2/3 solution for Postfix w/ PostgreSQL
...TION postfix_global_quota_check( IN localpart varchar, IN the_domain varchar, IN q_stor bigint, IN q_msgs bigint) RETURNS TEXT AS $$ DECLARE result text := 'DUNNO'; -- remove extenstion from localpart (user+foo -> user) lpart varchar := (SELECT regexp_replace(localpart, E'\\+.*$', '')); -- XXX how to handle alias addresses? -- stop here if the destination is an external address -- how to handle aliases with multiple destinations??? address varchar := lpart||'@'||the_domain; storage big...