All pastes #1548634 Raw Edit

Kristian allikmaa

public text v1 · immutable
#1548634 ·published 2009-08-30 22:06 UTC
rendered paste body
CREATE OR REPLACE FUNCTION show_credit (integer) RETURNS text
LANGUAGE 'sql'
SECURITY_CONTEXT = 'system_u:object_r:sepgsql_trusted_proc_exec_t:s0'
AS 'SELECT regexp_replace(credit, -[0-9]+, -xxxx, g) FROM customer WHERE cid = $1';