postgresql trigger

1）先在方法中创建trigger方法;

用new,old代替原来(sqlserver)的inserted等;

CREATE OR REPLACE FUNCTION "public"."update_etor_ticket_bianhao"()
  RETURNS "pg_catalog"."trigger" AS $BODY$declare 
strdate varchar;
strId varchar;
sid int;

BEGIN
  -- type your statements here

select new.id into sid;
select right(cast((power(10,8)+sid )as varchar),7) into strId;
SELECT TO_CHAR(CURRENT_DATE, 'yyyyMMdd') into strdate;

update etor_ticket set bianhao= concat(strdate,strId)  where id=sid;

RETURN NULL;

END$BODY$
  LANGUAGE plpgsql VOLATILE
  COST 100

2）在table的trigger中设置；