It's a pity. Why does not it listed in "Compatibility" section of create trigger documentation? I think, this makes "for each statement" triggers not compatible with SQL99.
2012/12/28 Pavel Stehule <pavel.stehule@xxxxxxxxx>
Hello
It has only one problem - PostgreSQL has not relations NEW and OLD for
>
> Also, for bulk insert, have you tried "for each statement" triggers instead
> of "for each row"?
> This would look like a lot of inserts and would not be fast in
> single-row-insert case, but can give you benefit for huge inserts.
> It should look like
> insert into quotes_2012_09_10 select * from new where cast(new.received_time
> as date) = '2012-09-10' ;
> insert into quotes_2012_09_11 select * from new where cast(new.received_time
> as date) = '2012-09-11' ;
> ...
statements triggers.
Regards
Pavel
Best regards,
Vitalii Tymchyshyn
