getting trigger to work
От | Merrill Oveson |
---|---|
Тема | getting trigger to work |
Дата | |
Msg-id | 3C975D6E.7C4F153D@actarg.com обсуждение исходный текст |
Ответы |
Re: getting trigger to work
|
Список | pgsql-general |
This function & trigger work: create function prosp_tf_bi() returns opaque as ' begin if new.pros_id is null then new.pros_id:= 1000; end if; return new; end; ' language 'plpgsql'; create trigger prosp_tr_bi before insert on prospector for each row execute procedure prosp_tf_bi(); This function & trigger don't work: create function prosp_tf_bi() returns opaque as ' begin if new.pros_id is null then new.pros_id:= A1000; end if; return new; end; ' language 'plpgsql'; create trigger prosp_tr_bi before insert on prospector for each row execute procedure prosp_tf_bi(); The error is "Attribute 'a1000' not found" The column pros_id is char(5). How do I put in the 'A1000'?
В списке pgsql-general по дате отправления: