author | Sylvain Thénault <sylvain.thenault@logilab.fr> |
Wed, 15 Apr 2015 22:08:08 +0200 | |
changeset 10327 | a504a7840915 |
parent 10326 | 03d98646d57c |
child 10328 | d7ff46d958f4 |
--- 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;;