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.steh...@gmail.com> > Hello > > > > > 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' ; > > ... > > It has only one problem - PostgreSQL has not relations NEW and OLD for > statements triggers. > > Regards > > Pavel > -- Best regards, Vitalii Tymchyshyn
