Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TYPE base.base AS
- (xx timestamp without time zone,
- yy timestamp without time zone,
- zz timestamp without time zone);
- CREATE OR REPLACE FUNCTION sch."updateTimestamp"()
- RETURNS trigger AS
- $BODY$
- BEGIN
- (NEW.base).xx = now();
- RETURN NEW;
- END;
- $BODY$
- LANGUAGE plpgsql VOLATILE;
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement