Project

General

Profile

« Previous | Next » 

Revision 12660

schemas/util.sql: added drop_column(regclass[])

View differences:

trunk/schemas/util.sql
1203 1203

  
1204 1204

  
1205 1205
--
1206
-- Name: drop_column(regclass[], text, boolean); Type: FUNCTION; Schema: util; Owner: -
1207
--
1208

  
1209
CREATE FUNCTION drop_column(tables regclass[], col text, force boolean DEFAULT false) RETURNS void
1210
    LANGUAGE sql
1211
    AS $_$
1212
SELECT util.drop_column((table_, $2), $3) FROM unnest($1) table_
1213
$_$;
1214

  
1215

  
1216
--
1217
-- Name: FUNCTION drop_column(tables regclass[], col text, force boolean); Type: COMMENT; Schema: util; Owner: -
1218
--
1219

  
1220
COMMENT ON FUNCTION drop_column(tables regclass[], col text, force boolean) IS '
1221
idempotent
1222
';
1223

  
1224

  
1225
--
1206 1226
-- Name: drop_relation(anyelement, boolean); Type: FUNCTION; Schema: util; Owner: -
1207 1227
--
1208 1228

  

Also available in: Unified diff