Project

General

Profile

« Previous | Next » 

Revision 14179

schemas/util.sql: added run_triggers(regclass)

View differences:

trunk/schemas/util.sql
4304 4304

  
4305 4305

  
4306 4306
--
4307
-- Name: run_triggers(regclass); Type: FUNCTION; Schema: util; Owner: -
4308
--
4309

  
4310
CREATE FUNCTION run_triggers(table_ regclass) RETURNS void
4311
    LANGUAGE sql
4312
    AS $_$
4313
SELECT util.eval($$UPDATE $$||table_||$$ SET $$||col_sql||$$ = $$||col_sql)
4314
FROM (SELECT quote_ident((util.first_col(table_)).name) AS col_sql) s
4315
$_$;
4316

  
4317

  
4318
--
4307 4319
-- Name: runnable_sql(text); Type: FUNCTION; Schema: util; Owner: -
4308 4320
--
4309 4321

  

Also available in: Unified diff