Sandbox2
Jump to navigation
Jump to search
Test
Test line
Sub Test
Sub test line
Update modified_date column on update
NEW.modified_date = now(); RETURN NEW;
END; $$ language 'plpgsql';
--or even better but more costly compute if only if content has changed
CREATE OR REPLACE FUNCTION update_modified_date_column() RETURNS TRIGGER AS $$ BEGIN
IF row(NEW.) IS DISTINCT FROM row(OLD.) THEN NEW.modified_date = now(); RETURN NEW; ELSE RETURN OLD; END IF;
END; $$ language 'plpgsql';
BEFORE UPDATE ON my_table FOR EACH ROW EXECUTE PROCEDURE update_modified_date_column();
print('test')
def testcodetag():
print('test'
def testcodetag():
print('test'
To manually overwrite a file while Template:Ic is set:
$ echo "output" >| file.txt