# HG changeset patch # User Sylvain Thénault # Date 1429128488 -7200 # Node ID a504a7840915f05f9b103a97854d62fb30df89c0 # Parent 03d98646d57c06832675cdee77cb600f90a9ed59 [postgres] _regproc.postgres.sql should be reloadable diff -r 03d98646d57c -r a504a7840915 schemas/_regproc.postgres.sql --- a/schemas/_regproc.postgres.sql Tue Apr 21 17:12:36 2015 +0200 +++ b/schemas/_regproc.postgres.sql Wed Apr 15 22:08:08 2015 +0200 @@ -11,6 +11,7 @@ $$ LANGUAGE SQL;; +DROP FUNCTION IF EXISTS cw_array_append_unique (anyarray, anyelement) CASCADE; CREATE FUNCTION cw_array_append_unique (anyarray, anyelement) RETURNS anyarray AS $$ SELECT array_append($1, (SELECT $2 WHERE $2 <> ALL($1))) $$ LANGUAGE SQL;;