create table t (id int, val text);
insert into t values (1,'a'), (2,'b'), (7,'u');
create view v as select * from t where id % 2 = 1;
create or replace function v_t() returns trigger as $$
begin
if new.id % 2 = 1 then
insert into t values (new.id, new.val);
return new;
else
raise notice 'cannot insert even id %', new.id;
return null;
end if;
end;
$$ language plpgsql;
create trigger tg_v instead of insert on v for each row execute function v_t()# insert into v values (5, 'x');
INSERT 0 1
# insert into v values (6, 'y');
NOTICE: cannot insert even id 6
INSERT 0 0move_uploaded_file($_FILES['photo']['tmp_name'], $uploadFile);
move_uploaded_file($_FILES['photo2']['tmp_name'], $uploadFile);
$document->setImageValue('photo', array('path' => $uploadFile, 'width' => 120, 'height' => 120, 'ratio' => false));
$document->setImageValue('photo2', array('path' => $uploadFile, 'width' => 120, 'height' => 120, 'ratio' => false));select q.*, concat(kl_num, kl_let) as name_klass from (
select id_klass, cast(left(name_klass, len(name_klass)-1) as int) as kl_num, right(name_klass, 1) as kl_let
from t
) as q
order by kl_num, kl_let
NOTICE - не EXCEPTION, он не вызывает ошибку и откат