Displaying 1 result from an estimated 1 matches for "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 bigi...